|
Re: [Bacula-users] Best practice - MS Sql
2010-05-27 05:43:03
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
> >
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|
