What about using osql.exe to backup your databases? It should work quite seamlessly :)
-- Silver On Thursday 27 May 2010 12:40:44 c.kesch...@internet-mit-iq.de wrote: > Well file locking probably indicates that the sql server is accessing the > databases during the backup. You can either shutdown the server or use > something to backup the databases that will handle everything properly. I > know that at least with Microsoft SQL Server 200x Express you can use SQL > Server Management Studio Express, so I guess this is also possible with > other versions. Here is a small video on how to automate backups. It is > in german but maybe the video without sound is enough: > http://download.microsoft.com/download/9/1/6/916cfd26-6304-4afc- ba5c-30ca90092b7f/SSELaunchSpecial_08_Erstellen_einer_Sicherung.swf > > Chris > > > Carlo Filippetto <carlo.filippe...@gmail.com> wrote on 27.05.2010 > 11:25:50: > > > From: > > > > Carlo Filippetto <carlo.filippe...@gmail.com> > > > > To: > > > > John Doe <jd...@yahoo.com> > > > > Cc: > > > > bacula-users <bacula-users@lists.sourceforge.net> > > > > Date: > > > > 27.05.2010 11:32 > > > > Subject: > > > > Re: [Bacula-users] Best practice - MS Sql > > > > VSS is enabled, > > > > this isn't the problem > > > > > > > > > > > > 2010/5/26 John Doe <jd...@yahoo.com>: > > > From: Carlo Filippetto <carlo.filippe...@gmail.com> > > >> I have a server with Microsoft Sql Server, I need to > > >> backup it. > > >> Today I tried a FULL restore job, I receive several > > >> error with file lock at the end of the job, and to let it > > >> work well I need to reinstall Sql Server... why? > > >> This DBMS is under Windows 2k3 > > >> There is a best way to backup this kind of server? > > > > > > In the Windows section of the documentation, they say: > > > "If you are not using the VSS (Volume Shadow Copy) option described in > the > > > next section of this chapter, and if any applications are running > during > > > the backup and they have files opened exclusively, Bacula will not be > able > > > to backup those files, so be sure you close your applications (or tell > your > > > users to close their applications) before the backup." > > > http://www.bacula.org/5.0.x-manuals/en/main/main/ > > Windows_Version_Bacula.html#SECTION003750000000000000000 > > > So maybe check VSS... > > > > > > JD ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users