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 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2006-10-09 : 22:20:10
|
| How do you guys do it?I'm starting to discover the pain of achieving a graceful sql uninstallation participating in a clusterI followed the ms articles but no luck. I am trying to avoid OS rebuild. Returning the mscs to configurable state is easy but the sql uninstallation is giving me some headachessystem is windows 2003 standard, mssql 2000 enterpriseotherwise, is there a way to repair win2k3? can't seem to find the option on the cd installer--------------------keeping it simple... |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-10-10 : 00:20:02
|
| Hi JenI had this problem before and it's exactly facing the same as yours. So I gave up this and just rebuilding the OS which is no issue for us due to we have a package deployment for server image which takes us only 15 minutes. Beside if you remove manually, it's not gonna be clean and in fact it's a cluster environment you don't want to face an issue down the track relating on this. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-10 : 01:42:55
|
| uninstall is done using the setup from the SQL installation. You need to run the setup from the node where you initially installed SQL.-ec |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-10 : 02:13:37
|
| This one is in build mode and I'm testing out scenarios and at the same time getting acquianted with the cluster behavior and setup.Thanks for sharing the experience Valdyv, I guess no workaround for this oneEC, weird is that the installation cd didn't give me an option to remove the sql server--------------------keeping it simple... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-10 : 02:32:51
|
quote:
Originally posted by jenEC, weird is that the installation cd didn't give me an option to remove the sql server
yeah, the uninstall is not very intuitive. Actually, the installation of SQL2K is not all that great either.Anyway, here are the steps that I follow (i just verified btw).- run the setup.bat from your installation (must have a drive letter, you cannot run setup.bat from UNC path)
- enter the name of the virtual host you want to modify
- select upgrade, remove, or add components
- select default or type in the instance name depending on what you have previously installed
- select uninstall instance
-ec |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-10 : 03:49:32
|
| thanks ec but I already checked those options, here's what I got:1. typing the virtual name, error says it's existing (can't proceed)2. if ever I do get to type in the same name, it's assuming a new install and gets an error a couple of steps forward, saying the file specified could not be found.3. if I do a force uninstallation using the regkey, same as #2Question, how do you do a graceful uninstallation? do you:1. uninstall sql server (on which node?)2. unclusteror1. remove nodes except one (where you ran the sql server installation)2. uninstall sql server on that node3. unclusterTIA--------------------keeping it simple... |
|
|
|
|
|
|
|
|
uninstallation of sql in a cluster