Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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