Hello Marek:

Which SQL command are you trying to use?  There are several ways to 
backup SQL Server databases with Bacula.

If you post your bacula-dir.conf or the complete Job resource, 
perhaps we can help.

1.) Shutdown the database server prior to the backup and restart it 
after the backup RunScript directives.

( These commands can be run from the Windows command shell or a batch file )

NET STOP MSSQLSERVER
NET START MSSQL SERVER

2.) Take a dump of the running database to a separate directory and 
back-up that directory.

( This SQL command can be scheduled from a SQL Agent job or run from 
the command-line or a batch file using the osql command )

BACKUP DATABASE MyDatabase TO DISK='C:\Backups\MyDatabase.bak'

Kindest regards,

Peter Buschman

At 09:36 14.7.2008, Marek Simon wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Hi,
>I need to backup some MSSQL server 2005 Database. I found, that there is
>some sqlcmd tool for it. When I run it on command line or through
>windows scheduler, it works. When I run it from bacula, sqlcmd do not
>work. I looked up the system log and I found nothing about the problem.
>Now I have set the MS SQL server run before the bacula backup, it works,
>but I would like to have it in bacula way. Does anybody meet this problem?
>
>Marek
>
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.4.6 (GNU/Linux)
>Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
>iD8DBQFIewHgxqkZ847NX44RAiAmAJ49K6ATuH5+LSnJH5VNQfTA121dDACgja2s
>aCI6/mVSypP+UO6gj7BdmR0=
>=snFm
>-----END PGP SIGNATURE-----
>
>-------------------------------------------------------------------------
>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


-------------------------------------------------------------------------
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