Restore to different sql server sql2000 sp3

[iainm2]

Hi
I am doing some DR testing and am trying to restore a complete sql server to a new server. I have been able to restore the data database files but when I restore the master database the mssql service always starts and after about ten seconds stops with the error "stopped with no error". I have copied the backup files to the new server and am restoring from that location. I can get the sql service to start ok after using rebuildm.exe. I have tried using different master database backup files from different dates. I am generally using Enterprise Manager to work with but have also tried following

http://support.microsoft.com/kb/304692/EN-US

which walks through using SQL Server Query Analyser which failed with the same result.
I am not a sql expert and am feeling my way into my role as db admin.
Many thanks

 

[SQLBI]

Hi,

Was there any particular reason why you had to restorethe system databases in addition to the user dbs? Have you made changes to Master/Model/Msdb on the original server that you need replicating on the new one

I maybe wrong, but i beleive you should simply install SQL onto your new server and then restore from the backups of the user DBs.


Cheers,
Leigh

You're only as good as your last backup!

 

[SQLBI]

Ahh, just viewd the link, didd't realise it was SQL 7.0.

Sorry if i've confused you.


Cheers,
Leigh

You're only as good as your last backup!

 

[SQLBill]

I believe you have to restore the system databases BEFORE you restore user databases.

-SQLBill

Posting advice: FAQ481-4875