SQL Server 2008 Service Pack 1 (SP1) Uninstall


By:   |   Updated: 2009-08-26   |   Comments (2)   |   Related: More > Install and Uninstall

Problem
In SQL Server 2008, I have heard that it is possible to Uninstall SQL Server 2008 Service Pack 1 (SP1) from an instance without actually removing the entire product. In this tip, we will go through the steps which you need to follow in order to Uninstall SQL Server 2008 Service Pack 1 (SP1).

Solution
It is recommended that before uninstalling SQL Server 2008 SP1, database administrators should take a full backup of all the user and system databases including the Resource database which was first introduced in SQL Server 2005. The Resource database is a read-only database that contains all the system objects that are included with SQL Server.

The database backups will help you to roll SQL Server back to the same state as it was, prior to the un-installation of SQL Server 2008 Service Pack 1 (SP1). 

Steps to Uninstall SQL Server 2008 Service Pack 1 (SP1)

1. Execute the below T-SQL query to verify the current SQL Server 2008 Service Pack Information.

SELECT 
SERVERPROPERTY('Edition') AS 'Edition', 
SERVERPROPERTY('ProductVersion') AS 'ProductVersion', 
SERVERPROPERTY('ProductLevel') AS 'ProductLevel', 
SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime', 
SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion' 
GO

 

2. Using Add or Remove Programs, Database Administrators can Uninstall SQL Server 2008 Service Pack 1 (SP1). In Add or Remove Program select the Show Updates check box and then choose Service Pack 1 for SQL Server 2008 which comes under Microsoft SQL Server 2008 and click the Remove button to begin the un-installation process.

3. This will open up the Uninstall Service Pack 1 for SQL Server 2008 screen as shown in the snippet below. Once all the prerequisite checks are successful, click Next to continue with the un-installation process.

4. In Select Features screen you can choose the feature which you want to remove the update. Click Next to continue with the un-installation process.

5. In Check Files in Use screen, the un-installation wizard actually checks for services and applications which are currently using files that setup needs in order to complete the un-installation of SQL Server 2008 Service Pack 1. Click Next to continue with the un-installation process.

6. In Ready to remove the update screen you can verify the features which you have selected so far to be updated. Click Remove to continue with the un-installation process.

7. In Removal Progress screen you will be able to see Success messages as soon as the un-installation of SQL Server 2008 Service Pack 1 (SP1) has successfully completed. Click Next to complete the un-installation process.

8. In Complete screen you will be able to see the message Your SQL Server 2008 remove update operation has completed successfully. You can also verify the un-installation process activities by going through the summary log. Click Close to end the un-installation process.

9. You can verify the SQL Server 2008 product version by executing the below mentioned query in SQL Server Management Studio (SSMS)

SELECT 
SERVERPROPERTY('Edition') AS 'Edition', 
SERVERPROPERTY('ProductVersion') AS 'ProductVersion', 
SERVERPROPERTY('ProductLevel') AS 'ProductLevel', 
SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime', 
SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion' 
GO

Next Steps

  • It's nice that there is finally an uninstall option for service packs.  Even though you probably won't have to do this very often it is nice to know that you can if you have to.
  • Download SQL Server 2008 Enterprise 180 Day evaluation from this site
  • List of the bugs that are fixed in SQL Server 2008 Service Pack 1 


Last Updated: 2009-08-26


get scripts

next tip button



About the author
MSSQLTips author Ashish Kumar Mehta Ashish Kumar Mehta has been contributing to the MSSQLTips.com community since 2009 with over 60 tips.

View all my tips
Related Resources





Comments For This Article




Monday, April 22, 2013 - 3:15:38 PM - raj Back To Top

Hi Ashish

I have confusion regarding roll backup service packs . As we heard that by replacing older version of resource database we can roll back service packs so why do we need to go through the uninstall process here.

Please clarify how SQL Server SP's can be roll backed on both sql 2005 and 2008.

 


Wednesday, August 26, 2009 - 1:25:16 AM - --cranfield Back To Top

thats excellent. What a relief knowing that you can uninstall without having to do a re-install.   Now, if only I could get the business to agree to upgrade to SQL2K8



download


Recommended Reading

Cleanly Uninstalling Stubborn SQL Server Components

Fix SQL Server Installation issue Wait on the Database Engine recovery handle failed with Single User Mode Login Option

SQL Server install error Wait on the Database Engine Recovery Handle Failed

SQL Server Setup Error - There was an error generating the XML document. Error code 0x84B10001.

SQL Server Installation Best Practices





get free sql tips
agree to terms


Learn more about SQL Server tools