locked
How does upgrading the SQL Server 2008 R2 to SQL Server 2008 R2 SP affect Project Server 2010? RRS feed

  • Question

  • We are planning to upgrade or current installation of SQL Server 2008 R2 to SQL Server 2008 R2 Service Pack 1 (SP1). This SQL Server instance hosts the databases for our Project Server 2010 environment.

    How do I find out how this will affect my Project Server 2010 environment?

    Thursday, January 5, 2012 7:14 PM

Answers

  • Hi Peter,

    Installing Service Pack 1 for SQL Server 2008 R2 should have no impact on your Project Server 2010 environment.

    But it is strongly recommended to test it first in a test environment to make sure everything still works as expected after installing SP1. Especially if you have a non-standard environment (non-English language, different localization settings, custom reports, ...)

    I hope this helps,
    Hans


    My EPM blog: Projectopolis
    Thursday, January 5, 2012 9:51 PM

All replies

  • Hi Peter,

    Installing Service Pack 1 for SQL Server 2008 R2 should have no impact on your Project Server 2010 environment.

    But it is strongly recommended to test it first in a test environment to make sure everything still works as expected after installing SP1. Especially if you have a non-standard environment (non-English language, different localization settings, custom reports, ...)

    I hope this helps,
    Hans


    My EPM blog: Projectopolis
    Thursday, January 5, 2012 9:51 PM
  • Hi Hans,

    Thank you for your reply. After the upgrade I'll post my results here.


    Thank you in advance, Peter
    Monday, January 9, 2012 4:53 PM
  • Everything upgraded without a hitch. I didn’t install the features as outlined here:  http://www.mysticslayer.com/?p=184


    Thank you in advance, Peter
    Saturday, January 21, 2012 12:32 AM