SAP SQL database cluster

30 pts.
Tags:
Microsoft Windows Server 2003
SAP interoperability
SQL Server 2005
SQL Server clustering
Hi Our sap configuration include two nodes on win 2003 cluster/ The cluster using us for SQL 2005 . I need to upgrade the hardware. It is possible to add two new nodes to the cluster ? It is downtime necessary if i want to replace one of the nodes ? it possible to install the sap software when the sap DB working on other nodes ? The sap basis guys do not have answers for me. Regards

Answer Wiki

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

If you have SQL Server 2005 Enterprise edition you can simply add the new nodes, install the required SQL Software (and any other software that is needed) move the SQL Server to one of the new nodes and power off the old nodes. After they are power off simply evict them from the cluster and you are done.

If you have SQL Server 2005 Standard edition you can only have two nodes in the cluster at a time. Because of this, you’ll need to remove one node and evict if from the cluster. Then add one of the new machines to the cluster and install the SQL Server software on it. Then fail over to the new node and remove the other old node. Then add in the other new node and install the SQL Software on it.

If done correctly the only down time that you will see will be while the SQL Server is failing over from one node to another which typically has a down time of 3-7 seconds.

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
  • Sabi13
    Hi Thank yo for your answer. But i am not sure the SAP software is like others , you can notify me if that the solution work with SAP also ?
    30 pointsBadges:
    report

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