Upgrading project server 2007 SQL 2005 DB to SQL 2008

[teekay37]

Does Project server 2007 support SQL 2008? If so can someone direct me to
the white papers on the proper procedure to migrate from SQL 2005 to SQL 2008?

 

[Ben Howard [MVP]]

The answer to the question is Yes, it supports 2008. As for a migration,
it's a question of backing up your farm and restoring it to a new SQL server.
I've done this once before, with some pain, though it was to the same
version of SQL (basically moving SQL servers to a bigger box). Moving it to
an new box, and new version adds another layer of complexity, but it can be
handled. I would allow lots of time to test this before hand

 

[Gerard Wojcik]

Teekay37 - I plan to do the following (hi-level steps) -
execute full farm backup (stsadm) -> detach farm -> restore farm from backup
- Central Admin- Operations - Backup and Restore (restoring databases to new
SQL Server 2008 instance). Of course you will Test test test - for testing
you will need to secure a another WFE server(s).

Yes, its supported - check the related TechNet article for more information:

Determine hardware and software requirements (Project Server)
http://technet.microsoft.com/en-us/library/cc197379.aspx

Check the note at the bottom of the article:
Office Project Server 2007 supports Microsoft SQL Server 2008. However, you
must install Windows SharePoint Services 3.0 with Service Pack 1 (SP1) or
later as well as Office Project Server 2007 SP1 or later before you install
SQL Server 2008.

Requirements for using SQL Server 2008 Analysis Services with the Project
Server 2007 Cube Building Service
http://technet.microsoft.com/en-us/library/dd285466.aspx

Integration of SQL Server 2008 and Office SharePoint Server 2007
http://technet.microsoft.com/en-us/library/cc990273.aspx

This article provides prescriptive guidance for implementing some of the new
features in Microsoft SQL Server 2008 that enhance the deployment of
Microsoft Office SharePoint Server.