Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

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


By:   |   Read Comments (4)   |   Related Tips: More > Upgrades and Migrations

Attend these FREE MSSQLTips webcasts >> click to register


Problem

The company where I work is planning to install SQL Server 2008 Service Pack 1 (SP1). I have heard that the installation process for SQL Server 2008 Service Pack is different from previous SQL Server Editions.  How much different is the installation process? In this tip, we will review the SQL Server 2008 Service Pack installation process, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.

Solution

It is recommended that before applying any service pack on SQL Server, 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.

Database Administrators should read the readme.txt file which comes with Service Pack Installation before applying the Service Pack. However, Database Administrators should first apply the service pack on development and test servers before applying on production servers. If there are no issues reported in the development and test Environments after testing your applications, then you can apply them on the production servers. Here are the essential steps that can make your SQL Server 2008 Service Pack (SP1) installation as smooth as possible:

  1. Download SQL Server 2008 SP1.
  2. Development environments:
    1. Issue a full backup of all user and system databases including the Resource database.
    2. Take note of all the Startup parameters, Memory Usage, CPU Usage etc.
    3. Install the service pack on development SQL Servers.
    4. Create a backup and restore plan with the steps for "What to do if application is not working properly after installing the new Service Pack?"
  3. Test environments:
    1. Issue a full backup of all user and system databases including the Resource database.
    2. Take note of all the Startup parameters, Memory Usage, CPU Usage etc
    3. Install the service pack on test SQL Servers.
    4. Conduct testing for administrative process as well as coordinate testing with the Development and QA Teams to ensure the application is performing as expected.
    5. Test the rollback plan.
  4. Production environments:
    1. Plan for a scheduled downtime on the Production Servers as it takes approximately 30 minutes to apply the service pack on SQL Server 2008.
    2. Issue a full backup of all user and system databases including the Resource database.
    3. Take note of all the Startup parameters, Memory Usage, CPU Usage etc
    4. Install the service pack on test SQL Servers.
    5. Validate the application is working properly.

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

1. Download SQL Server 2008 Service Pack 1 (SP1) from the following link.
2. Double Click Setup.exe to extract the Service Pack installation files from the setup.

open file security warning

3. Once setup files are extracted go to the folder where the files are extracted and click Setup.exe. This will open up SQL Server 2008 Service Pack 1 screen as shown in the snippet below. In the Welcome screen the SQL Server 2008 Setup program will check for few rules before applying the Service Packs. If any of the rules are failing, the installation will not continue further. Hence, you need to fix those issues before continuing with the installation.

sql server service pack

4. In License Terms screen, read the license agreement and then select the check box at the bottom of the page to accept the licensing terms and conditions of the product. Click Next to continue with the installation.

license terms sql server

5. In Select Features screen, select the SQL Server Instance and select the features of SQL Server 2008 which need to be upgraded. A brief description about each feature is shown in the right side panel along with the Language, Edition, Patch Level, Architecture, Service Pack and Upgrade Status when each of the features is selected. The different components which are available for upgrade within SQL Server 2008 are mentioned below:

  • Database Engine Services
    • SQL Server Replication
    • Full-Text Replication
  • Analysis Services
  • Reporting Services
  • Shared Features
    • Business Intelligence Development Studio
    • Client Tools Connectivity
    • Integration Services
    • Client Tools Backwards Compatibility
    • Client Tools SDK
    • SQL Server Books Online
    • Management Tools - Basic
      • Management Tools - Complete
select features

Once all the features are selected click Next to continue with the SQL Server 2008 Service Pack 1 (SP1) installation.

6. In Check Files In Use screen the setup will check for SQL Server related files which are currently being used. If there are any such files then they need to be released before performing the Service Pack installation. Click Next to continue with the installation.

check files in use

7. In Ready to Upgrade screen you can verify the list of features which will be upgraded during the installation. If you are fine with the list of features, then click Upgrade to perform the actual Service Pack installation.

ready to update

8. In Upgrade Progress screen you will be able to see the installation progress. It will approximately take 30 minutes to complete the installation. The installation time varies depending upon the hardware configuration.

update progress

9. Once the Service Pack installation is successful you will be able to see the Success message as shown in the snippet below.

update progress

10. On the Complete screen you will be able to see "Your SQL Server 2008 update operation has completed successfully" message. Click Close to end the installation setup.

service pack complete

11. You can verify the SQL Server 2008 Service Pack 1 (SP1) installation by executing the query below 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

developer edition
Next Steps
  • Download SQL Server 2008 Enterprise 180 Day evaluation from this site
  • Identify which SQL Server version you are currently running from this tip
  • Download SQL Server 2008 Service Pack 1 from this site
  • List of the bugs that are fixed in SQL Server 2008 Service Pack 1


Last Update:


signup button

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





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Monday, March 17, 2014 - 2:51:19 PM - KIRAN Back To Top

Hi

I have installed the sql server 2008 enterprise Enterprise Edition10.0.1442.32CTP2008-05-30 01:32:01.16310.00.1442

For this how can i upgrade to latest version? (Like sql server 2008 Ent Edition 10.0.2531.0 SP1)

Thanks in Adance....



Thursday, October 24, 2013 - 10:55:46 AM - ben Back To Top

I've an HP DL380P GEN 8-SFF CTO Server with a MS Windows Server 2012 system and i want know if the installing process (Steps to Install) of MS SQL Server 2008 SP1  is the same as describe.  

 


Monday, March 18, 2013 - 1:33:27 AM - Kareem Syed Back To Top

Hi,

Please check may be you are not applying proper SP to your instance. It happens in the following scenarios

1. If you are working with SQL Server 2008 R2 but trying to apply SQL Server 2008 SP.

2. You have mentioned that you are working with 64 bit but may be you are applying SP of 32 bit.

Hope the answer is clear and usefull.

Thanks

Kareem.S


Wednesday, October 17, 2012 - 11:17:23 AM - Frie Back To Top

please help me the 5th step it didnt specify the features to update it is empity for me I dont know y ....what can i do help me please. my computer is window 7 SP 1 Operating system 64 bit


Learn more about SQL Server tools