Information générale
Forum:
Microsoft SQL Server
Titre:
How to simulate disaster recovery
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement