question

user-1308 (google) avatar image
user-1308 (google) asked

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

sql-server-2005restoreclustering
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.