clinno's blog

1. SQL Server 2000 Restore pre-requirement:

(1)You need to backup the following database : master , msdb and your own databases.
(2)sa's default database must be in database master.
(3)The new server's installed directory must be as the same as original one.
(4)New Server's version and server pack must be the same.

2.Open Enterprise Manager.

3.Restore database , msdb.

4.Now ready to restore database , master. Please stop SQL server and open a DOS prompt window. Change to the installed directory of SQL ,usually it should be in C:\Program Files\Microsoft SQL Server\MSSQL\Binn. Enter the following command to let SQL Server running in Single-User Mode, sqlservr.exe -c -m.

5.Re-open Enterprise Manager.

6.Restore database, master.

7.When SQL Server prompt the 'reconnect' message, please choose NO. At this moment, SQL server is shutdown when you successfully restore database , master.

8.Restart SQL Server, and Open Enterprise Manager to restore all your own database.

*This method could restore all your jobs and packages in the new server.