Service Pack 2 Uninstall Not Possible for SQL Server 2005
Written By: Chad Boyd -- 2/23/2007 -- 0 comments
-- printer friendly --
become a member
|
|
Tired of deadlocks, locking/blocking, slow queries and poor
performance?
SQL performance tuning analyzes your SQL
environment, identifies your performance issues, and provides solutions to fix your performance problems
permanently.
We know where your performance problems are hiding
|
|
Problem
You probably already know that SQL Server 2005 SP2 has been released. This is a good thing if you are in need of one of the changes that are included in this service pack. In a previous tip, SQL Server 2005 - Service Pack 2, we took a look at what was to be included in this second service pack for SQL Server 2005. The question that you often face is should I install this service pack. One thing to note before you install SP2 is that there is no way to uninstall it once it is installed.
Solution
One nice feature that you have probably become accustomed to is the ability to uninstall programs, hot fixes and service packs by using the Add/Remove Programs feature of Windows. With SQL Server 2005 there is no easy way to uninstall the service packs. For both SQL Server 2005 SP1 and SP2, in order to get back to the previous version you need to do a complete reinstall of SQL Server 2005.
Below is a short snippet from the SQL Server 2005 SP2 readme file.
| 1.3 Uninstalling SQL Server 2005 SP2
Once SQL Server 2005 SP2 has been applied, it cannot be removed without uninstalling the entire product.
To remove SP2 and revert to the previous version of SQL Server 2005
- Using Add or Remove Programs, uninstall the instance of SQL Server 2005 .
- Reinstall SQL Server 2005.
- Apply any hotfixes that were previously installed.
- Note: Additional steps are required to revert to the previous version of SQL Server 2005. For more information, see the SP2 Setup documentation.
|
Below is a screen shot after selecting Remove for SQL Server 2005.
Following are links to the SQL Server 2005 services packs readme files and uninstall steps.
- SQL 2005 SP1
- SQL 2005 SP2
As you can see, a rollback from an SP2 installation requires a complete reinstall of the SQL Server 2005 instance - something to definitely take into consideration for planning your update to SP2.
Nest Steps
- Before you install SP2 find a test and development environment that you can use to do preliminary testing
- Refer to this previous tip to see if there are items in this service pack release that you really need
- Create a rollback plan in case there are issues after you install SP2
- Test, test, test before you deploy to your production servers
- Special thanks to Chad Boyd of the MSSQLTips.com community for this tip.
Readers Who Read This Tip Also Read
Comment or Ask Questions About This Tip
 Twitter This Tip!
|
