Installing SP2 for SQL server 2005

  • Hi all,

    Our current SQL server 2005 version is :

    Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    Recently Our AlertSite security monitoring service made the report against our server and marked it HIGH severity. So we need install security patches released by microsoft.

    Here is the link :

    http://www.microsoft.com/technet/security/bulletin/ms08-040.mspx

    For these security patches, we need to install SP2 for SQL server 2005. We'll be downloading and testing SP2 on test machine before trying it on PROD server.

    I am not a DBA and dont know much about what issues we could face in this migration. Would there be any problems ?

    Please share your thoughts.

    Also, I read that SP2 can not be uninstalled [url=http://www.mssqltips.com/tip.asp?tip=1186]http://www.mssqltips.com/tip.asp?tip=1186[/url] and it needs complete uninstallation of SQL server 2005. Is that correct ?

  • We'll be downloading and testing SP2 on test machine before trying it on PROD server.

    I am not a DBA and dont know much about what issues we could face in this migration. Would there be any problems ?

    Please share your thoughts.

    Go ahead and intall SP2 on the test machine.

    If there is any issue, it will be available to view during setup. Also everything is logged in the folder \Setup bootstrap\LOG.

    SP2 setup will need server rebooting.

    To be on safer side, take backups.

    And do this on week end, so that if something happens you have suffecient time to rollback.

  • Thank you Suresh.

Viewing 3 posts - 1 through 2 (of 2 total)

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