uninstalling multiple instances

Question

uninstalling multiple instances

bodhilove

SSCarpal Tunnel

Points: 4035
More actions
August 12, 2008 at 6:41 pm

#190936

Hi,
I have a problem with uninstalling multiple instances.
I have installed multiple instances on a sql server and tried to patch them with SP2 all together. the update hung on me because I ran out of disk space so I assumed that the instances are now bad. Also I want to move the instances to another drive so I believe I will need to uninstall them all. The problem is using Add/Remove Programs does not uninstall the instances properly and after you uninstall the first instance you cannot use this anymore. This is further complicated by the fact I have working production instances on the server which I don't want to take offline if it can be help. I have seen som doco from Microsoft that uninstalls instances manually but it is only for a single instance and also looks like I will have to take my critical dbs offline which I only want to do in last resort.. any advice would be appreciated.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

I've removed instances by using Add/Remove Programs. The problem you're running into with that might be because of disk space issues.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Venkatesan Prabu SSCommitted Points: 1892 More actions · Answer 2

Curious to know,

How you install the sql server instance?

Regards,

Venkatesan Prabu .J

http://venkattechnicalblog.blogspot.com/

Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:

http://venkattechnicalblog.blogspot.com/

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

you can also run the SQL setup from cd and that can be used to modify installed instances

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 4

If you updated with SP2, it should have only been for one instance. Is that not the case?

You uninstalled once instance, how many do you have and are they others working correctly?

My thought is that you would want to reinstall your uninstalled instance first in the place you need it and go from there. You will need to take the other instances offline at some point to move them. However the SQL files aren't large. You can move data/log files with minimal interruption.