DR for SQL 2000 from backups only.

1. Restore master on instance.

• Restart instance with –m –c [-s InstanceName]
• Restore master (osql –E –S [machine\instancename])
• RESTORE DATABASE Master FROM DISK = 'master_forDR.bak'WITH replace
• --Instance automatically turns off.

2. Restart instance with –Q –T3608 [-s InstanceName]

•  Turn off instance after restart

 

3. Start SQL Service as in from Services.msc & restore System databases

 

RESTORE DATABASE [msdb] FROM DISK = N'msdb_forDR.bak' WITH FILE = 1,
MOVE N'MSDBData' TO N'data\msdbdata.mdf', MOVE N'MSDBLog' TO N'data\msdblog.ldf',
NOUNLOAD, STATS = 10

 

RESTORE DATABASE [model] FROM DISK = N'model_forDR.bak' WITH FILE = 1,
MOVE N'modeldev' TO N'data\model.mdf', MOVE N'modellog' TO N'data\modellog.ldf',
NOUNLOAD, REPLACE, STATS = 10

 

a. All the system databases are up while user databases are marked as suspect

 

select name , databasepropertyex (name,'status') from sysdatabases

  and now you can restore your system databases as in normal no need to migrate logins & jobs.