RE: [Bacula-users] Mssql backup

2006-05-02 Thread James Harper
> Is there any way to backup MsSql properly. I am doing file system backup > already. Depends on what you mean by 'properly' :) The current proper way to get bacula somehow to make MSSQL execute an SQL statement like: BACKUP DATABASE yourdb TO DISK='C:\temp\yourdb.bak' WITH INIT Before the back

Re: [Bacula-users] Mssql backup

2006-05-02 Thread drescher0110-bacula
> I think I can backup Mssql via Enterprise Manager or command promt. > > Arunav. What you want to do is to create an sql script and use a command line database program to execute this script when it is called via bacula's RunBeforeJobClient command. I did not spell that all out earlier baecause

Re: [Bacula-users] Mssql backup

2006-05-02 Thread Arunav Mandal
- Original Message - From: "Dan Langille" <[EMAIL PROTECTED]> To: "Arunav Mandal" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 02, 2006 11:13 PM Subject: Re: [Bacula-users] Mssql backup On 2 May 2006 at 22:43, Arunav Mandal wrote: - Original Me

Re: [Bacula-users] Mssql backup

2006-05-02 Thread Dan Langille
On 2 May 2006 at 22:43, Arunav Mandal wrote: > > - Original Message - > From: "Dan Langille" <[EMAIL PROTECTED]> > To: "Arunav Mandal" <[EMAIL PROTECTED]>; > > Cc: > Sent: Tuesday, May 02, 2006 9:31 PM > Subject: Re: [Bac

Re: [Bacula-users] Mssql backup

2006-05-02 Thread Arunav Mandal
- Original Message - From: "Dan Langille" <[EMAIL PROTECTED]> To: "Arunav Mandal" <[EMAIL PROTECTED]>; Cc: Sent: Tuesday, May 02, 2006 9:31 PM Subject: Re: [Bacula-users] Mssql backup On 2 May 2006 at 21:07, Arunav Mandal wrote: - Or

Re: [Bacula-users] Mssql backup

2006-05-02 Thread Dan Langille
On 2 May 2006 at 21:07, Arunav Mandal wrote: > > - Original Message - > From: "Dan Langille" <[EMAIL PROTECTED]> > To: "Arunav Mandal" <[EMAIL PROTECTED]> > Cc: > Sent: Tuesday, May 02, 2006 8:46 PM > Subject: Re: [Bacula-users]

Re: [Bacula-users] Mssql backup

2006-05-02 Thread Arunav Mandal
- Original Message - From: "Dan Langille" <[EMAIL PROTECTED]> To: "Arunav Mandal" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 02, 2006 8:46 PM Subject: Re: [Bacula-users] Mssql backup On 2 May 2006 at 20:42, Arunav Mandal wrote: Can't I run som

Re: [Bacula-users] Mssql backup

2006-05-02 Thread Arno Lehmann
Hello, On 5/2/2006 8:46 PM, Dan Langille wrote: On 2 May 2006 at 20:42, Arunav Mandal wrote: Can't I run some sort of prejob with bacula and then run bacula so that database is dumped properly and then file system backup starts. Yes. You want RunBeforeJobClient Counting peas: Client Run

Re: [Bacula-users] Mssql backup

2006-05-02 Thread Dan Langille
On 2 May 2006 at 20:42, Arunav Mandal wrote: > Can't I run some sort of prejob with bacula and then run bacula so that > database is dumped properly and then file system backup starts. Yes. You want RunBeforeJobClient -- Dan Langille : Software Developer looking for work my resume: http://www.

Re: [Bacula-users] Mssql backup

2006-05-02 Thread Arunav Mandal
quot; <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 02, 2006 6:57 PM Subject: Re: [Bacula-users] Mssql backup MsSql is a problem with any backup app. The trick is to go into maintenance as sa and schedule nightly backups to file from within MySql (I can't be specific on exactly where to do

Re: [Bacula-users] Mssql backup

2006-05-02 Thread drescher0110-bacula
> MsSql is a problem with any backup app. The trick is to go into > maintenance as sa and schedule nightly backups to file from within MySql > (I can't be specific on exactly where to do this 'cause I don't have a > MsSql server in ready access at this time). Once done, you backup the > offline

Re: [Bacula-users] Mssql backup

2006-05-02 Thread Eric Smoker
Arunav Mandal wrote: Is there any way to backup MsSql properly. I am doing file system backup already. MsSql is a problem with any backup app. The trick is to go into maintenance as sa and schedule nightly backups to file from within MySql (I can't be specific on exactly where to do this 'cau

Re: [Bacula-users] mssql backup with bacula

2005-06-30 Thread Russell Howe
Kilaru Sambaiah wrote: > Hello All, > I am looking for mssql database backup using bacula. > Is it possible using some third party softwares? >How to go about it? Here I define a maintenance plan which dumps the databases to files, and then tell bacula to back up those files. I also have