none
SQL Server 2005 SP2 Update to SP4

    Question

  • Hi!

    We are currently running two SQL Server 2005, one Enterprise x64 as database server and one Standard x86 as SRSS host. Both are still on SP2, the Enterprise is 9.0.3257 and Standard 9.0.3353. Since SP4 and CU1 are out I want to update both servers .

    I just wanted to ask if somebody else did an upgrade from SP2 to SP4 and if there were any problems in the update process or if it all went smoothly.

    Just a short answer is anything I need to ease myself :)

    Thank you!

    Friday, January 14, 2011 10:28 AM

Answers

All replies

  • Hi Joey,

    I understand the changes to SQL 2005 SP2 and SQL 2005 SP4 are not critical and no new features or major changes were added to SP4. In short I believe you should be fine to upgrade. I would still recommend it is best practice to ensure that you have a full system backup of the servers you are upgrading before you upgrade. Also I would perform the upgrade outside office hours.

    Have a look at SP3 release notes; - http://download.microsoft.com/download/5/7/1/5718A94A-3931-457B-8567-AA0995E34870/ReleaseNotesSQL2005SP3.htm

    Have a look at SP4 release notes; - http://social.technet.microsoft.com/wiki/contents/articles/microsoft-sql-server-2005-sp4-release-notes.aspx

    I hope the above helps.

    Kind Regards,

    Kieran.


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood
    • Proposed as answer by Kieran Patrick Wood Friday, January 21, 2011 1:13 PM
    • Marked as answer by Joey_DE Friday, January 21, 2011 1:31 PM
    Friday, January 14, 2011 3:52 PM
  • Hi All,

    I've to upgrade 2005 SP1 to SP4. I'm not sure how we can roll back in case of any problem. SQL 2008 SP1 gives option to remove service pack from add/remove prg. Not sure about SQL 2005 SP4. Anyone has any information around this??

    Thanks,

    Jayesh

    Thursday, January 27, 2011 1:26 PM
  • Hi Jayesh,

    You have made a full system backup of the servers you are upgrading before you upgrade havn't you?

    Kind Regards,

    Kieran.


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood
    Friday, January 28, 2011 11:13 PM
  • I just did the SP4 update yesterday and it went very good. Not a single problem at all. I installed CU1 after a reboot too.

     

    Friday, February 04, 2011 8:13 AM