My jobdefs for MS SQL 2005 Express:

ClientRunBeforeJob = "C:\\bacula\\dump.bat"

Content of dump.bat:
osql -S MY_HOST -U MY_USERNAME -P MY_PASSWORD -i c:\bacula\dump.sql

Content of dump.sql:
(many rows like that)

BACKUP DATABASE [DATABASE_NAME] TO  DISK = N'C:\SOMETHING
\DATABASE_NAME.BAK' WITH NOFORMAT, INIT,  NAME = N'DATABASE_NAME-Full
Dump', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

Andrea


-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users