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