Sept 20, 2010
In this article we will take a look at how to install a SQL Server 2008 Service Pack. It is the primary responsibility of a SQL Server Database Administrator to make sure all the SQL Servers within the organizations are applied with the latest Security Updates, Cumulative Updates and Services Packs which are released by Microsoft from time to time. In this article we will take a look at how to install a SQL Server 2008 Service Pack.
Database Administrators can get the complete list of all the Cumulative Updates and Service Packs for SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 by reading the article titled Microsoft SQL Server Build Lists . The steps mentioned in this article are applicable for installing SQL Server 2008 Service Pack 1 and Service Pack 2.
Important Note . It is highly recommended that database administrator should backup all User and System database along with Resource database before applying any Security Updates, Cumulative Updates or Service Packs. Resource database is a read only database which stores all the system objects which are included in SQL Server. This database is invisible in management studio and this was first introduced in SQL Server 2005. To know more about Resource database read the article titled Resource Database
"This article has a total of 2 pages including this page. Click the links below to open all 2 pages in a seperate window to learn How to Install SQL Server 2008 Service Pack. Page 1 , Page 2 "
Best Practices to follow before installing a SQL Server Service Pack
1. Perform a full backup of all User, System and Resource database.
2. Note down of the important SQL Server Configuration Settings, Startup Parameters, Linked Servers, and Script out SQL Server Agent Jobs, Script out SQL Server Logins, Memory Utilization, CPU and Disk Utilization etc.
3. Create an appropriate Service Pack Deployment and Rollback Plan
4. Always install Service Packs first in Development environment and then test all applications which are using SQL Server.
5. Once everything looks good in development environment, then only install Service Pack in QA environment. Test all applications which are using SQL Server in QA environment and also test your rollback plan.
6. If everything look good in both Development and QA environment then plan to install Service Pack in a Production environment by communicating an appropriate downtime window to the stake holders and database/application users.
7. Once the Service Pack is installed successfully in a Production environment perform sanity checks to confirm all applications are working fine.
8. Reboot the SQL Server once Service Pack / Cumulative Updates or a Security
Updates are applied successfully on the server.
9. If everything looks goods then release the Production environment for user activities and monitor the environment closely for a week or two to make sure there are no unusual spikes in CPU and Memory Utilizations.
Install SQL Server 2008 Service Pack
Let us now start with installing SQL Server 2008 Service Pack 2. You can follow the steps mentioned in this article to apply Service Packs on all Editions of SQL Server 2008. If you are using an RTM version of SQL Server 2008 then you can directly apply SQL Server 2008 Service Pack 2 as this has all the fixes of Service Pack 1.
1. Identify which Version and Edition of SQL Server you are using in your environment and then download the latest available SQL Server 2008 Service Pack from Microsoft website. You can also get the complete list of all the Cumulative Updates and Service Packs for SQL Server 2005. SQL Server 2008 and SQL Server 2008 R2 by reading the article titled Microsoft SQL Server Build Lists .
2. Right click the downloaded SQL Server 2008 Service Pack Executable file and then select Run as Administrator option from the drop down as shown in the below snippet.
3. In the Welcome screen of SQL Server 2008 Service Pack. the Setup wizard will check whether all the prerequisites are met before the service pack installation begins. If you encounter any error then you need to resolve them before continuing with the service pack installation.
4. In the License Terms screen you must accept the Microsoft Software License Terms and then click Next to continue with the service pack installation.
5. In the Select Features Screen you can choose the database instance on which you want to install SQL Server 2008 Service Pack. If you want to install service pack only on a default instance then you need select MSSQLSERVER as shown in the below snippet. If you would like to install service pack on a named instance then you need to select the named instance to install service pack on the named instance. Click Next to continue with the service pack installation.
6. In the Check Files In Use screen it will check for services and applications which are using files that SQL Server 2008 Service Pack Setup will require. If there are any such services and applications which are using files required for the service pack setup then you need to stop the process or else you should restart the SQL Server before applying SQL Server Service Pack. Click Next to continue with the service pack installation.