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 > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
