June 25, 2012 at 5:33 am
Hi
How would you solve this issue??
windows 2008, SQL server 2008R2
3 instances
instance 1 and 2 critical applications.
instance 3 - a few none critical applications
Instance 1,2 have the right coallition
Instance 3 have wrong coalltion, need to change this.
One way would be
1. Backup objects/ login and so on...
2. Pause Node 2
3. Put Sqlservice (resource) offline
4. Perform rebuild.
However even if this might be a fast rebuild since its fast and good hardware etc..
We still need the failover option for instance 1 and 2 and if we paus node 2 that option wont be available.
Another way would be to uninstall the instance and reinstall it.
We thought about put resource offline and perform rebuild (skip the node paus) we are not sure how the cluster will react we don't want it try or do a failover.
How would you do this rebuild?
June 25, 2012 at 3:54 pm
kenneth.holm (6/25/2012)
HiHow would you solve this issue??
I would follow this KB article 😉
kenneth.holm (6/25/2012)
One way would be1. Backup objects/ login and so on...
2. Pause Node 2
3. Put Sqlservice (resource) offline
4. Perform rebuild.
You do not need to perform step 2, see the url I posted above.
kenneth.holm (6/25/2012)
Another way would be to uninstall the instance and reinstall it.We thought about put resource offline and perform rebuild (skip the node paus) we are not sure how the cluster will react we don't want it try or do a failover.
you do not need to uninstall and reinstall. From the active node put the SQL server resource offline and run the rebuild as detailed in the url above.
How would you do this rebuild?[/quote]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 26, 2012 at 6:42 am
Thanx, i will go with this approach.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply