Uninstalling a SQL Server Service Pack

Did you know that starting with service packs (Service Pack 1) in SQL Server 2008 you can uninstall them from Add/Remove Programs like any other update?

image

But as always, backup both your user and system databases before applying any update, hot fix, cumulative update, or service pack!

If you are still using SQL Server 2005 or older, you have to use the manual method detailed here:

HOW TO: Remove a SQL Server Service Pack
https://support.microsoft.com/kb/314823

- Jay