Thursday, March 22, 2012

Backing up and restoring SQL Server

I want to reformat my servers harddrive and install a newer operating
system (Win 2003). I am running SQL Server 2000 with about 10
databases. What is the best way to backup and restore SQL Server for
this so I don't lose anything.
Thanks,
RickRick (rick@.abasoftware.com) writes:
> I want to reformat my servers harddrive and install a newer operating
> system (Win 2003). I am running SQL Server 2000 with about 10
> databases. What is the best way to backup and restore SQL Server for
> this so I don't lose anything.

Look at http://support.microsoft.com/defaul...kb;EN-US;224071.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

No comments:

Post a Comment