Re: How to turn the SQL off so a backup can be done

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 17:42:45 -0500

Why not use the native SQL backup tools? They can create a self-describing,
transactionally consistant backup without taking the server offline. Read
the section in BOL (Books-OnLine) on Backup and Restore. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"t_radd67@hotmail.com" <anonymous@discussions.microsoft.com> wrote in
message news:e58301c40ba3$73b5de10$a401280a@phx.gbl...
>   I would like to know how to turn off the sql and the do
> a backup and then turn the sql back on after the backup is
> done.
>  -Action 1 -Silent 1
>     -Service MSSQL$WinFiler_MSDE
>     -ExePath "C:\Program Files\Microsoft SQL
> Server\MSSQL$WinFiler_MSDE\Binn\sqlservr.exe"
>      -Server .\WinFiler_MSDE
>

Relevant Pages

  • Re: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Scheduled Backup for SQL Database
    ... Look in the SQL Server log too, ... Need smaller SQL2K backup files? ... >>Need smaller SQL2K backup files? ...
    (microsoft.public.sqlserver.server)
  • SQL/ MS 2003 server backups/restores
    ... I'm a bit confused on the backup necessary for my SQL server running on MS ... system state, OS etc, and another for my SQL databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Backup erros
    ... You may have a SQL ... Error 800423f4 appears in the backup log file when you back up a volume by ... > Reason: The process cannot access the file because it is being used by> another process. ...
    (microsoft.public.windows.server.sbs)