Post reply

SQL 2008 SP2 installation

  • October 4, 2010 at 1:48 pm

    #239269

    All,

    I am applying Service Pack 2 to my sql server 2008 instance. Below are the current installation details,

    select @@VERSION -- Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)

    SELECT SERVERPROPERTY('productversion') -- 10.0.1600.22

    SELECT SERVERPROPERTY ('productlevel') -- RTM

    SELECT SERVERPROPERTY ('edition') -- Enterprise Edition (64-bit)

    Can you please provide me you any specific things to consider during this?

    Thanks in advance...

  • October 4, 2010 at 2:26 pm

    #1231278

    You can apply SP2 without applying SP1 first; SP2 is cumulative.

  • October 4, 2010 at 2:29 pm

    #1231280

    Thanks Jeff... I will directly apply SP2 then...

    any other suggestions?

  • October 4, 2010 at 2:37 pm

    #1231286

    Not this early. Past experience doesn't lead me to worry TOO much, though testing it first is essential obviously.

  • October 4, 2010 at 2:59 pm

    #1231303

    And unlike SQL 2005, you can actually uninstall a SP in 2008! woo!

    We used to have peer to peer replication in SQL 2005 SP2, and I upgraded to SP3 without testing this, since we don't have replication set up in QA. Completely blew up replication...I had to reinstall SQL from scratch since I couldn't roll back to sp2.

    That's the only time I've ever wished I could uninstall a SP..but it was a pretty important one.

  • October 4, 2010 at 3:24 pm

    #1231316

    apply to test servers first and backup system databases before and after.

    Personally I stop SQL beforehand and take flat file copies of the system databases as well (including resource database), but then I am a belt and braces guy.

    ---------------------------------------------------------------------

  • October 4, 2010 at 5:27 pm

    #1231373

    This is a QA sever. Can other developers use the server to query database while the SP2 installation is in progress?

    Do I need to restard SQL Server or reboot the machine?

  • October 4, 2010 at 6:10 pm

    #1231384

    apat (10/4/2010)

    This is a QA sever. Can other developers use the server to query database while the SP2 installation is in progress?

    Do I need to restard SQL Server or reboot the machine?

    You should schedule a down time for performing this - users should not be in the database while it is going on. The SP will stop/start the services as needed during the install, but I did not need to reboot any machines (I updated 4 dev servers (7 instances) on Thursday/Friday).

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 4, 2010 at 6:13 pm

    #1231385

    Thank You WayneS.......

  • October 7, 2010 at 2:11 pm

    #1233920

    When installation runs checked files in use it shows wmiprvse.exe and fdhost.exe is currently on. can I stop that and start after install?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply