Thank's, very good ideas,
I found nice script to make db backup
(http://www.mssqltips.com/tip.asp?tip=1070), this isn't the problem,
the question is why when I tried to restore the full machine the "Sql
Server Management" did not start? it don't work, and in 'Services'
there where no process to start..

I can understand that without the domain the server can't start, but I
had error on server so I nedded to reinstall all.

Anyone has well restored a full server with MS Sql and have a good job
where all work fine?

CIAO

---
Carlo Filippetto




2010/5/27 Silver Salonen <silver AT ultrasoft DOT ee>:
> 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
>

------------------------------------------------------------------------------

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users