[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 647
  • Last Modified:

removing one instance from multiple instances in sql server 2005

There are two sqlserver instances running in sql server 2005 (Clustered environment), windows 2003 server. I want to remove one instance from the server.
what are steps to be followed before removing/uninstal the instance and how can i check if there are any dependies between the two iinstances.

refered links: http://kbalertz.com/909967/uninstall-instance-Server-manually.aspx
                      http://msdn.microsoft.com/en-us/library/ms143412(SQL.90).aspx

please, let me know how far the above links are helpfull.

Regards,
Krishna
0
krishna_harik
Asked:
krishna_harik
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
<< how can i check if there are any dependies between the two iinstances. >>

If you have two instances that means you have two independent instances running on that server. Hence No need to check for any dependencies.

However make sure that you have the necessary backups of required databases in the instance which you are going to delete / remove.

First Link helps you out to uninstall an instance from a clustered environment.
This link from MSDN gives you more insight on it.
http://msdn.microsoft.com/en-us/library/ms190438(SQL.90).aspx

Second link helps you to uninstall in a normal environment.

Below will be helpful to you.
http://support.microsoft.com/kb/922670
http://support.microsoft.com/kb/909967

If you want to delete the default instance, hope this would be helpful too.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23635161.html
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now