How to restore a broken server into the existing SQL cluster?

Hi, I am in a situation that one SQL server in a cluster has unrecoverable broken. I have to rebuild it from scratch. The cluster had two nodes. Another server is servicing clients now. Currently, I built the OS on the broken one already. But I have no idea what to do after. I try google but have no luck. Could someone advise me? Details: - Windows 2003 32bits o Working node is not R2. It is 2003 first version. o Broken node was rebuilt with 2003 R2. - Use MS Windows cluster o The old cluster still exists on the working node. I evicted the broken node from the MS cluster. So only one node in cluster now. - Use SQL server 2005 o Old server still service on the working node. I am worry about the existing configurations of the broken node that persists on working node. Do I need to delete them first? - Databases are in SAN o Do I need to backup database out from SAN before restore? Thank you, Somchai

more ▼

asked May 27, 2010 at 08:16 AM in Default

avatar image

user-1308 (google)
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 27, 2010 at 08:16 AM

Seen: 1530 times

Last Updated: May 27, 2010 at 08:16 AM

Copyright 2018 Redgate Software. Privacy Policy