Saturday, August 17, 2013


Uninstalling SQL Server 2008

By: Editor 
March 26, 2009

Page: 1/4 

Introduction

This article is a step by step guide which can be used by database administrators to uninstall SQL Server 2008 Enterprise Edition.
"This article has a total of 4 pages including this page. Follow the links below to open all 4 pages in a seperate window to learn how to Uninstall SQL Server 2008. Page 1Page 2Page 3Page 4"
1. Click Start | Control Panel | Add or Remove Programs. In the Add or Remove Programswindows select Microsoft SQL Server 2008 as shown in the snippet below and Click Change/Remove button.
Add or Remove Programs

2. Once you click on Change/Remove button it will popup SQL Server 2008 windows as shown in the snippet below. There are three options basically available and they are Add, Repair and Remove.
  • Add:- This option can be used by database administrators if they want to add any new feature of SQL Server 2008 which you may not have installed previously. The different features can be adding Analysis Services, Integration Services , Reporting Services or Replication etc.
  • Repair:-This option can be used by database administrators if they want to repair SQL Server 2008 product.
  • Remove:- This option can be used by database administrators if they want to remove SQL Server 2008 product. This is the option which you need to select to Uninstall SQL Server 2008.

SQL Server 2008 Add, Repair or Remove Screen
3. Once you click on Remove option, you will see a popup screen informing you to wait for a while till SQL Server 2008 Setup is processing the current user request.
4. In SQL Server 2008 Setup Support Rules screen SQL Server setup program identifies problem which can occur when you uninstall SQL Server. If there are no issues encountered they you will see Passed message against each rule. Click OK to continue with the uninstallation.

SQL Server 2008 Setup Support Rules Screen 

5. In Select Instance screen select the SQL Server Instance from where you need to remove features. This can be done by selecting the instance name from the drop down list as shown in the snippet below. Click Next to continue with the uninstallation process.

Select SQL Server Instance From where you want to uninstall features 

6. In the Select Features screen choose the feature which needs to be removed and click Next to continue with the uninstallation process.
 


7. In the Removal Rules screen you could see that SQL Server setup program is checking internally whether the uninstallation process will be successful or not. You will be able to see the status for Removal architecture mismatch as true if there are no issues in uninstalling SQL Server 2008. Click Next to continue with the uninstallation process.


8. In the Ready to Remove screen SQL Server 2008 setup will ask you to verify the SQL Server 2008 features which will be removed. click Next to continue with the uninstallation process.

MORE SQL SERVER ARTICLES

ALSO READ ... HOW TO INSTALL SQL SERVER 2008 R2 
HOW TO INSTALL SQL SERVER 2012


SIGN UP TODAY FOR MYTECHMANTRA.COM NEWSLETTER
LIKE US ON FACEBOOK   |  FOLLOW US ON TWITTER

 
9. Once the requested features are removed, the Removal Progress screen which will have the Success or Failure message for each and every single feature which it has removed. Click Next to complete the uninstallation process.





10. In the Complete screen you will be able to see “Your SQL Server 2008 removal completed successfully”. Click Close to exit Remove SQL Server 2008 setup.

 

Conclusion

In this article you have seen the steps which database administrator needs to follow to uninstall an instance of SQL Server 2008 manually.


Read more: http://www.mytechmantra.com/LearnSQLServer/Uninstalling_SQL_Server_2008_P4.html#ixzz3h4tKB1c5
Follow us: @MyTechMantra on Twitter | MyTechMantra on Facebook



Read more: http://www.mytechmantra.com/LearnSQLServer/Uninstalling_SQL_Server_2008_P1.html#ixzz3h4srz6D4
Follow us: @MyTechMantra on Twitter | MyTechMantra on Facebook