none
Is Project server 2007 [version 12.0.0.6421] compatible with SQL server 2008 ? RRS feed

  • Question

  • Hello Sir.

    We originally set up a Project server 2007 system using SQL server 2005 for the backend DBs. Now we want to manually move those Databases/instance to a SQL server 2008 environment. Is this possible? What are the possible options?

    Thanks.

    Thursday, April 12, 2012 2:41 PM

Answers

  • Hi there,

    Yes, SQL 2008 is supported. Migrating to a new SQL server by moving the databases is fine providing you have used a SQL Alias / DNS alias for the SQL 2005 Server when installing Project Server 2007. If you haven't you will need to create a SQL Alias (on all app / web servers) / DNS Alias that points the old SQL 2005 server name to the new SQL 2008 server name.

    Highl level steps below:

    • shut down the app / web servers
    • take full DB backups of all SharePoint and Project Server databases
    • script out the delete expired session SQL job
    • Copy these to the new SQL 2008 server
    • Restore the DBs with the same names to the SQL 2008 server
    • execute the script to create the delete expired sessions job
    • Set up the permissions for the accounts on the new SQL 2008 server
    • either repoint or create the SQL aliases / DNS alias for the SQL server
    • configure SQL Analysis services
    • turn on all web / app servers
    • Test the farm

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Thursday, April 12, 2012 3:31 PM
    Moderator

All replies

  • Hi there,

    Yes, SQL Server 2008 is supported. But manually moving databases is not right option. You need to take farm backup , disconnect the farm, build new farm using new SQL server and restore farm backup.


    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn

    Thursday, April 12, 2012 2:57 PM
    Moderator
  • Hi there,

    Yes, SQL 2008 is supported. Migrating to a new SQL server by moving the databases is fine providing you have used a SQL Alias / DNS alias for the SQL 2005 Server when installing Project Server 2007. If you haven't you will need to create a SQL Alias (on all app / web servers) / DNS Alias that points the old SQL 2005 server name to the new SQL 2008 server name.

    Highl level steps below:

    • shut down the app / web servers
    • take full DB backups of all SharePoint and Project Server databases
    • script out the delete expired session SQL job
    • Copy these to the new SQL 2008 server
    • Restore the DBs with the same names to the SQL 2008 server
    • execute the script to create the delete expired sessions job
    • Set up the permissions for the accounts on the new SQL 2008 server
    • either repoint or create the SQL aliases / DNS alias for the SQL server
    • configure SQL Analysis services
    • turn on all web / app servers
    • Test the farm

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Thursday, April 12, 2012 3:31 PM
    Moderator
  • Hello Paul.

    With regards to the "configure SQL Analysis services" part,  is a general installation/configuration or does it have to becustomized further for our environment and what links would you recommend other than the below?

    http://technet.microsoft.com/en-us/library/dd285466(v=office.12).aspx

    thank you very much :-)

    Friday, April 13, 2012 3:32 PM
  • Hi there,

    Just follow the TechNet link :-)

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Friday, April 13, 2012 3:40 PM
    Moderator