> 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 backup, and to and make sure it completes without errors. Bacula would need to use isql to issue the above statement (assuming you have the client tools installed). This will give you a backup the 'yourdb' database in a file called C:\temp\yourdb.bak. You then need to get bacula to back up that file. The restore procedure is to use bacula to restore the file back to C:\temp, and then execute some SQL like: RESTORE DATABASE yourdb FROM DISK='C:\temp\yourdb.bak' I'm currently attempting to put together an FD (or at least something that the director thinks is an FD) which will allow backing up an MSSQL database direct to bacula without worrying about running scripts etc. I'll post more when I have it working. James ------------------------------------------------------- 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&kid0709&bid&3057&dat1642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
