March 19, 2010 at 1:28 pm
We have a 2 node Windows 2003 active/passive SQL 2005 failover cluster. OS is on SP2 and SQL build is 4035. It is fairly new and is not in production yet, and I have been asked to uninstall SQL server on the passive node, as it had some issue with the ip address.
What is the procedure I need to follow here. I am listing my steps here, please suggest the correct method
1.Remove node B from the cluster
2.Uninstall SQL server on node B
3.Add the node b back to the cluster
Is that right? Also, I have two drives local to each nodes is that correct?
Thanks..
March 19, 2010 at 3:33 pm
What are you planning to do? You intend to have a working SQL cluster at the end?
March 19, 2010 at 3:55 pm
Please refer to this document for info on how to add or remove a node from clustering.
http://msdn.microsoft.com/en-us/library/ms191545(SQL.90).aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply