> 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 files rather than the running/locked files. > > Eric > > I do that with an sql command like the following which I run from the command line:
use MASTER go BEGIN DECLARE @string_var varchar(30) DECLARE @file_name varchar(50) SET @string_var =CONVERT(varchar(30),getdate(),112) if exists (select * from sysdatabases where name='TMDataBase') begin SET @file_name = 'd:\Backups\TMDataBase.'[EMAIL PROTECTED]'.bak' BACKUP DATABASE TMDataBase TO DISK = @file_name RESTORE FILELISTONLY FROM DISK = @file_name end if exists (select * from sysdatabases where name='MageeMammoSQL') begin SET @file_name = 'D:\Backups\TMDataBase.'[EMAIL PROTECTED]'.bak' BACKUP DATABASE MageeMammoSQL TO DISK = @file_name RESTORE FILELISTONLY FROM DISK = @file_name end if exists (select * from sysdatabases where name='TMCallbacks') begin SET @file_name = 'd:\Backups\TMCallbacks.'[EMAIL PROTECTED]'.bak' BACKUP DATABASE TMCallbacks TO DISK = @file_name RESTORE FILELISTONLY FROM DISK = @file_name end ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
