How do I remove a named instance of sql server 2008 on the same mssql server?
If you have two instance in SQL Server 2008 and what are are the steps to remove one instance from SQL Server?
To remove a named instance of sql server 2008, follow these steps
1. Navigate to Control Panel->Add/Remove Programs
2. Select Microsoft SQL Server 2008
3. Select Change/Remove
4. Select Remove
5. At Select Instance spefify the instance of SQl Server to modify
Select the instance of SQl Server to remove. To remove management tools and shared features only, select “Remove shared features only” and then click next
Removal progress will go through and remove named instance of sql server 2008 on the same mssql server