I am trying to restore databases from server A to server B, which both run SQL2000 SP2.

Server_A:
DB_1
DB_2
userA

Server_B:
DB_3
DB_4
userB

The intention is to have server B as a fail over server, using backup files from server A. Thus it is acceptable if databases on server B are wiped.

I have tried restoring the master database from Server_A onto Server_B. However, SQL server no longer be able to start, as it tries to find the database files for DB_1 and DB_2.

My question are:
a) Which order do I restore the backups? DB_1, DB_2, then Master?
b) Is there anyway to restore master DB but removing those DB references? Or changing those DB references?

Any web url ref would be great too

Thanks heaps.

James.