July 10, 2012 at 10:04 am
Hi
we have 2 node cluster and I was installing SP1 in one node and when it was installing on the 2nd node the setup crashed
and now i go end up having 2 version in our cluster.
I tryed re-run the setup but came up with an error as previous installation encountered errors and its not moving beyond this point. and i also cant run a repair same error.
So my plan is to uninstall SQL and install it again will that be a problem on a 2 node cluster?
node 1 is fine its works fine and i can not fail over this node 2 to node 1
July 10, 2012 at 4:46 pm
Is this an OS service pack you're installing or the SQL server service pack?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 12:51 am
its SQL SP1 patch
July 11, 2012 at 1:02 am
I would uninstall\remove the node that's causing the issue and re install it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 1:05 am
you mean from the cluster to do a Evict?
or uninstalling SQL Server from that node is better?
July 11, 2012 at 4:00 am
try just uninstalling sql server first
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 4:11 am
ok i can do that, after that will i be able to install the new instance?
have anyone done that?
July 11, 2012 at 4:39 am
you'll be adding the node back to the current instance not creating a new one!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 5:36 am
i was thinking to completely un-install the sql instance and not to remove the node from the cluster
July 17, 2012 at 12:56 am
In a clustered environment you cannot unistall SQL Server unless you remove it from Cluster first.
In your situation,
Step1: Remove SQL Server from Cluster(for doing this run the setup and remove the node from the cluster)
Steps2: Uninstall SQL and all other components related to SQL
Steps3: Run the SQL Server setup and add node again.
Thanks
S.R.Kundur
July 17, 2012 at 3:57 am
Damian-167372 (7/11/2012)
i was thinking to completely un-install the sql instance and not to remove the node from the cluster
no, just run setup and remove the node (which uninstalls just that node) the instance will still be active on the partner. Remove the node from the windows cluster too if necessary.
Clean the server up and then add it back to the cluster (if you removed it) then re run the add node wizard to re introduce the node to the clustered instance. Slipstream any SPs and\or CUs during the install process to match the version you have installed.
For slipstreaming see my guide at this link[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply