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

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.

Answer 1

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

Answer 2

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

Answer 3

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 :-)

Answer 4

Hi there,

Just follow the TechNet link :-)

Thanks

Paul

---

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