SQL Tutorials

How To Add Or Remove SQL Server 2008/2008 R2 Instances

                                     

                                           How To Add Or Remove SQL Server 2008/2008 R2 Instances

Description:

SQL server 2008 or 2008 R2 databases  also create duplicate instance or additional instance which was not necessary.In some cases it will effect the performance of the sql tables loading time.To remove the additional instance here is the steps.

Steps:

– Login to the server with administrator login details.

– Before start this process take the back of existing databases.And masterDB log files also.

– Now go control panel and click on Programs and Features.
How To Add Or Remove SQL Server instances
–  Click on Microsoft SQL Server 2008 R2(64-bit) and click on uninstall.

– In new window SQL Server 2008 R2 Add,Repair,Remove will open.
How To Add Or Remove SQL Server instances01
– Click on Remove it will open Remove SQL Server 2008 R2.

– Select the instance which you want to delete from the instance to remove features from.

How To Add Or Remove SQL Server instances02

– features window will open select the features which was not depending on the default instances.Click on remove.
How To Add Or Remove SQL Server instances03
Note: While select the features do not select Shared Features it will effect to the default instance..

For Adding instance from SQL Server 2008 R2 Add,Repair,Remove window select Add button.

Tags:SQl,SQl server,SQL 2008,SQL 2008 R2,SQL server 2008 R2 Installation,SQl Server 2008 R2 Instance,SQl default Instances,SQl Articles.