I have SQL Server 6.5 running on our production machine and on a development machine. I would like to simulate a disaster in which the production machine is unavailable and the data has to be restored to the development machine, which would chug along until we get the production server back.

My problem is in restoring the master database. I can restore the dev server's own master database, but when I try to do a restore using the tape backup of the prod server's master, SQL won't restart. It throws an NT error (I forget the number, but it's the one that indicates a problem with the master database.)

Is there a trick to restoring the master database from a different server? Would I perhaps need to rename the dev server to match the name of the production server?

BTW, Michael Levy if you read this I took your VFP design class a couple of years ago and it was great.

TIA,

Ross