Re: Online Backups

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 18:39:21 -0000

Yes , the native SQL backups are all online operations. You can then use
backup software of your choice to backup those native SQL backups to tape.
You can backup direct to tape from SQL but it is often more convenient to
backup to disk if you can afford the space. 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jason" <anonymous@discussions.microsoft.com> wrote in message
news:4fad01c3ff9a$9bbdcea0$a101280a@phx.gbl...
> OK, so if I use the backup program found in the
> Enterprise Manager MMC of SQL 2000 then it will do an
> online backup?
>
> Thanks,
>
> Jason
>
> >-----Original Message-----
> >You almost never want to backup SQL Server at the file
> level, especially
> >while it is running. A backup should be done with the
> native SQL BACKUP
> >command or thru an appropriate third party plug-in.
> >
> >-- 
> >Andrew J. Kelly  SQL MVP
> >
> >
> >"Jason" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:1d5f01c3ff81$25ef9c30$a601280a@phx.gbl...
> >> Hi,
> >>
> >> I wanted to find out if the backup software that comes
> >> with Windows Server 2003 will backup my databases
> online -
> >>  while they are running, or do I have to buy the full
> >> version of Veritas and get an agent?  I was hoping
> volume
> >> shadow would make it possible, but I'd just like to
> make
> >> sure.
> >>
> >> thanks in advance.
> >
> >
> >.
> >

Relevant Pages

  • 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)
  • 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: SQL 2005 Failing Backups Because it Exits The Query Prematurely
    ... it might be a behavior change in SQL 2005. ... SQL 2005 Failing Backups Because it Exits The Query Prematurely ... This same application (which uses ODBC) is able to backup SQL 7.0 and SQL ...
    (microsoft.public.sqlserver.odbc)
  • Re: hi, need help
    ... manual hand-jam on the SQL backend through a discovered parameter. ... restore from that backup you took last week. ... ask the provider for a backup (if you dont have a backup ...
    (Security-Basics)
  • SQL 2005 Failing Backups Because it Exits The Query Prematurely
    ... This same application is able to backup SQL 7.0 and SQL ... The query is not being called asynchronously by the client app. ... I've tried connecting using both the SQL Native Client in ODBC and the SQL ...
    (microsoft.public.sqlserver.odbc)