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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-05-06 : 02:07:42
|
| On one of our servers there is two instances of SQL Server loaded (don't ask why as I can't fathom it, it was said to have been installed for the use of an external contractor!).Anyway, I would like to remove this second instance and reclaim all the resources for our (main) instance (as assume it is using RAM as well as other - diskspace), has anyone any ideas as to the best way to tackle it as none of the tables/data within the database that the second instance contains is used anymore. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-06 : 02:15:32
|
The easiest way would be to simply close or turn of the service for the second instance.The other way would be to run the setup application and chose uninstall and select the proper instance name.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-05-06 : 02:25:53
|
quote:
Originally posted by Peso
The easiest way would be to simply close or turn of the service for the second instance.
E 12°55'05.63"N 56°04'39.26"
We did this, but unfortunately when our server is re-booted the second instance starts up as well.quote:
Originally posted by PesoThe other way would be to run the setup application and chose uninstall and select the proper instance name.
E 12°55'05.63"N 56°04'39.26"
This would mean putting the disk in the drive and selecting from whatever menu comes up? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-06 : 02:28:42
|
quote:
We did this, but unfortunately when our server is re-booted the second instance starts up as well.
you have to configure via the Admin Tools - Services not to start up that instance
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-05-06 : 03:16:04
|
| OK, thanks for that, I've logged into the server and disabled those services that use the second instance, they were set to 'Automatic'. |
|
|
|
|
|
|
Removing a second instance of SQL Server