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.
Arunav.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Eric Smoker" <[EMAIL PROTECTED]>; "Arunav Mandal"
<[EMAIL PROTECTED]>
Cc: <bacula-users@lists.sourceforge.net>
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 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
