How to install SQL Server 2008 SP2

Applies to: Microsoft SQL Server 2008.


Download SQL Server 2008 SP2.

Please download SQL Server 2008 SP2 from here.

Risk Analysis.

• Run Microsoft SQL Server 2008 R2 Best Practices Analyzer to identify potential problems. It works for SQL Server 2008.

• Test SQL Server 2008 SP2 on a test environment.

• Contact vendors of third-party software using your database server and get their approval.

Requirements.


• The windows account used to run the SP2 setup program must have administrator privileges on the computer where SP2 will be installed.

• All features of the SQL Server instance must be at the same version level.

• The disk space needed for the installation depends of the size of the SP2 package you need to install:


SQL Server Express Packages:

- SQLEXPR32_x86 (can be installed on both 32-bit and 64-bit operating systems): 275 MB

- SQLEXPR_x86 (can be installed on 32-bit operating systems): 240 MB

- SQLEXPR_x64: 308 MB


All Other Editions of SQL Server:

- X86: 750 MB

- X64: 918 MB

- IA64: 898 MB

Pre-installation tasks.


• Backup system databases.

• Backup user databases.

• Run DBCC CHECKDB on all databases and verify that there were no errors or inconsistencies reported.

• Stop all applications and services that make connections to the instance being upgraded. You cannot stop services in a failover cluster environment. Antivirus software and monitoring applications should be stopped.

• Disable DDL Triggers.

• Verify that SQL Server 2008 Service Accounts are not disabled.

• Resources that have dependencies on SQL Server resources must be removed or taken offline prior applying SP2.

• Protocols: please make sure at least Shared Memory protocol.

• Do not stop the following services:

- Alerter
- Cluster Service
- Com+ System Application Service
- Computer Browser
- Cryptographic Services
- DHCP Client
- Distributed File System
- Distributed Link Tracking Client
- Distributed Link Tracking Server
- DNS Client
- Event Log
- IPSEC Policy Agent
- License Logging Service
- Logical Disk Manager
- Messenger
- Net Logon
- Network Connectors
- NTLM Security Support Provider
- Plug and Play
- Process Control
- Remote Procedure Call (RPC) Service
- Remote Registry Service
- Remote Procedure Call (RPC) Locator
- Removable Storage
- Security Accounts Manager
- Server
- Spooler
- Task Scheduler
- TCP/IP NetBIOS Helper
- Telephony
- Time Service
- Windows Time Service
- Windows Management Instrumentation Driver Extensions
- Workstation
- Services required by SAN or network adapters online.

Installation.

Normal (non-clustered) installation:

- To install SQL Server 2008 SP2, run the self-extracting package file. Run SP2 Setup.






System Configuration Check scan the computer immediately looking for conditions that may block SQL Server 2008 Setup.





Click on the "Show details" button to display the scan results.






Please accept Microsoft License terms.





 
All components and features are pre-selected.





SQL Server setup check for files in use that may force a restart after SP2 has been applied.








Click on "Update" to start the installation.














SP2 successfully installed.






- After applying SP2, install cumulative update package 1 for SQL Server 2008 Service Pack 2
(KB2289254) . SP2 includes hotfixes of SQL Server 2008 SP1 Cumulative Update 1 to 8 only. Cumulative update package 1 for SQL Server 2008 Service Pack 2 contains all hotfixes included on SQL Server 2008 SP1 Cumulative Update 9 to 10.


Installing SP2 on a failover cluster environment:

- Do not stop the cluster service during installation or before applying SP2.
- Do not stop any running processes before running SP2 Setup.
- Run SP2 Setup on the active node. This will cause downtime. If you would like to avoid downtime, please see KB958734.
- After applying SP2, install cumulative update package 1 for SQL Server 2008 Service Pack 2 on the active node.
(KB2289254). SP2 includes hotfixes of SQL Server 2008 SP1 Cumulative Update 1 to 8 only. Cumulative update package 1 for SQL Server 2008 Service Pack 2 contains all hotfixes included on SQL Server 2008 SP1 Cumulative Update 9 to 10.

Installing SP2 on an environment using Database Mirroring:

For environments using Database Mirroring, please see the following article:

http://technet.microsoft.com/en-us/library/bb497962.aspx 

Installing SP2 on an environment using Replication:

For environments using replication, please apply SP2 on the following order: the distributor first, then the publisher, and finally the subscriber. For more information, click here:

Installing SP2 on an environment using Log Shipping:

Apply SP2 on the secondary server first, and then apply it on the primary server. No need to stop Log Shipping. For more information, click here.



Post-installation Tasks.

- Please read SQL Server Setup log files to verify all features were updated successfully. Click here for instructions.
- Restart each node of the cluster.
- Restart services that have dependencies on SQL Server.
- Verify proper operation of client applications.
- Backup system databases after successful installation.
- If the cluster was using mixed mode authentication, please verify it was not changed to Windows Authentication.



Rollback Plan.


Use Control Panel (Programs and Features or Add/Remove Programs) to uninstall SQL Server 2008 SP2, after it has been installed successfully.






If the installation fails then setup may roll back or not, depending of the cause of the failure.



References.


1. Microsoft Support.

2. Microsoft SQL Server 2008 SP2 Release Notes.


 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.