SAP SQL database cluster
Home > IT Answers > SQL Server > SAP SQL database cluster
Sabi13
30 pts.
0
Q:
SAP SQL database cluster
SQL Server 2005, SAP interoperability, Windows Server 2003, 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
ASKED: May 3 2009  11:50 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: May 4 2009  7:57 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Sabi13   30 pts.  |   May 5 2009  6:25AM GMT

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 ?

 
0