Home > Archive > MS SQL Server > December 2006 > NTBackup









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author NTBackup
Diane Walker

2006-12-05, 7:12 pm

We are running SQL 2000, Enterprise Edition on Windows 2003 Standard Edition
server. We setup SQL database backup from the Enterprise Manager and we
plan to use NTBACKUP utility to backup the entire serve to a tape drive. My
question is when I use NTBACKUP, do I exclude the SQL databases or it makes
no difference? Thanks.


Hari Prasad

2006-12-06, 12:12 am

Hello,

Use NT backup to backup the database Backup files; Please exclude the
datbaase files (MDF, LDF and NDF) files if the SQL Server service is online.

Thanks
Hari

"Diane Walker" <ett9300@yahoo.com> wrote in message
news:egOLvFMGHHA.4920@TK2MSFTNGP05.phx.gbl...
> We are running SQL 2000, Enterprise Edition on Windows 2003 Standard
> Edition server. We setup SQL database backup from the Enterprise Manager
> and we plan to use NTBACKUP utility to backup the entire serve to a tape
> drive. My question is when I use NTBACKUP, do I exclude the SQL databases
> or it makes no difference? Thanks.
>



Diane Walker

2006-12-07, 12:12 am

Thank you very much.

"Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
news:uDXFTOOGHHA.4688@TK2MSFTNGP04.phx.gbl...
> Hello,
>
> Use NT backup to backup the database Backup files; Please exclude the
> datbaase files (MDF, LDF and NDF) files if the SQL Server service is

online.
>
> Thanks
> Hari
>
> "Diane Walker" <ett9300@yahoo.com> wrote in message
> news:egOLvFMGHHA.4920@TK2MSFTNGP05.phx.gbl...
Manager[color=darkre
d]
databases[color=dark
red]
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com