Thursday, February 16, 2012

Backup

We are running SQL Server 2000, SP3. Do we need to stop SQL service before
backing up all the database (master, msdb, etc.)?
Thanks.No, SQL Server has always allowed you to back up a database while the server
is running.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jill Johnson" <jjohnson362000@.yahoo.com> wrote in message
news:#TVYkJfZDHA.4020@.tk2msftngp13.phx.gbl...
> We are running SQL Server 2000, SP3. Do we need to stop SQL service
before
> backing up all the database (master, msdb, etc.)?
> Thanks.
>|||Thank you, Kalen.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uaBGjNfZDHA.1280@.tk2msftngp13.phx.gbl...
> No, SQL Server has always allowed you to back up a database while the
server
> is running.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Jill Johnson" <jjohnson362000@.yahoo.com> wrote in message
> news:#TVYkJfZDHA.4020@.tk2msftngp13.phx.gbl...
> > We are running SQL Server 2000, SP3. Do we need to stop SQL service
> before
> > backing up all the database (master, msdb, etc.)?
> >
> > Thanks.
> >
> >
>

No comments:

Post a Comment