SQL 2005 Active/Active/Passive

15 pts.
Tags:
SQL
SQL Server 2005
SQL Server clustering
We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. Because the cluster is a production server, I need to know exactly how I add a new node onto the current cluster without breaking anything. Also this is my first time to install a passive node, so it is difficult for me to understand how to install and configure it.
ASKED: April 23, 2008  6:23 PM
UPDATED: April 24, 2008  1:06 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

First take the new machine and add it into the cluster, just like you did when adding the second machine to the cluster.

Now edit the resource groups for the two SQL instances and tell them that they can use the third machine.

Then start the SQL installer. When you go through the installer there should be a repair option. In there is should ask you what you want to do with one of the options being something to the effect of add a node to the cluster. It will then push the SQL files and services to the new machine. You will then need to run SP2 (or what ever post SP2 hot fix you are on) to all three nodes in the cluster.

Then repeat with the second instance. Fail the instances to all three nodes to ensure that everything is working correctly.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following