How to do a Full Disaster Recovery
If you are doing a disaster recovery of an entire SQL 2005 cluster, can you just install SQL server and restore the system database to get the configuration?
September 10th, 2015 2:34pm

Yes. YOu are correct. YOu need to rebuild the SQL instance and restore your system and user databases.

In the cluster if one node fails second node will take over and runs. If second node also fails that is complete down.

YOu need to rebuild the SQL server and restore all databases.

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 1:27am

If you are doing a disaster recovery of an entire SQL 2005 cluster, can you just install SQL server and restore the system database to get the configuration?

You can get the configuration ofcourse but you wont get user databases you have to manually restore them. First restore master then msdb then model database.
September 11th, 2015 3:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics