What about using osql.exe to backup your databases? It should work quite 
seamlessly :)

-- 
Silver

On Thursday 27 May 2010 12:40:44 C.Keschnat AT internet-mit-iq DOT 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.filippetto AT gmail DOT com> wrote on 27.05.2010 
> 11:25:50:
> 
> > From:
> > 
> > Carlo Filippetto <carlo.filippetto AT gmail DOT com>
> > 
> > To:
> > 
> > John Doe <jdmls AT yahoo DOT com>
> > 
> > Cc:
> > 
> > bacula-users <bacula-users AT lists.sourceforge DOT 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 <jdmls AT yahoo DOT com>:
> > > From: Carlo Filippetto <carlo.filippetto AT gmail DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users