SAP SQL database cluster
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
Software/Hardware used:
Software/Hardware used:
ASKED:
May 3, 2009 11:50 AM
UPDATED:
May 5, 2009 6:25 AM
RELATED QUESTIONS
- Can I add a local SQL 2005 instance to a clustered node
- cluster install node failure when adding
- Failover clustering in windows 2003 environment.
- SQL Server Fails to Start When Moved to Different Node
- moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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 ?