Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
 Posted - 2010-12-17 : 08:22:54
|
| I have a cluster with three nodes.Have a group with sql server installed.Want to uninstall the sql server instance.Note: remove node just removes the instance from one node (and leaves the services disabled). It is still available to the other nodes.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-17 : 08:32:41
|
| Think it's just the add remove programs uninstall thingy. I think that is cluster aware and will uninstall everything.Anyone know?ANd the next question is what if a node has been removed - wil it still clear up things on that node?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-17 : 09:10:43
|
| Actually the add remove programs is for sql server not for an instance.Maybe you hae to remove from all nodes in the cluster indevidually.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-12-17 : 12:38:11
|
| Check if this helps: http://msdn.microsoft.com/en-us/library/ms190438(v=SQL.90).aspxDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-12-17 : 13:13:31
|
| The uninstall is not just to remove the programs - you are given the option to uninstall each of the various components.And yes, this should remove that instance from all nodes that are currently connected. If you have removed a node (evicted) that node without removing SQL Server from the node first, then you might have problems removing SQL Server completely. I am not sure though - since I have never tried it.Jeff |
|
|
|
|
|
|
Remove sql server instance from cluster