There have been more times then I care to admit where I have been trying to do something and while I was doing that task I did not understand what it was asking for. Many of these times I find myself asking for a detailed step by step check list. The problem with the detailed checklists are that they don’t always cover your situation.
This week I found myself installing a new SQL Server Cluster and I kept coming across error after error. It appears that I have somehow managed to install SQL Server without the name of the SQL Server cluster being assigned to it. This left me in a spot where I wanted to uninstall the product but, when I tried to remove SQL Server it would not do so and just repeating back to me with an error telling me that the Instance name of ” was already in use. Since this wasn’t a valid name all my efforts to remove it were in vain.
This is where the checklist aspect comes in, After we had the servers rebuilt I was able to find a great step by step article. There have been a number of changes made with the install of SQL Server on a cluster, Using a step by step like this helps you understand the changes, this excellent one that I am referring to was written by Edwin Sarmiento.
Now if I could find a checklist on how to manually remove SQL Server 2008 without using the Add/Remove Programs I would be all set.