Creating New Databases w/ Project Server 2007 - Is It Possible?

[Andy S]

I installed Project Server 2007 in a two server environment, 1
application server and 1 database server. Our database server
contains both SQL 2000 and SQL 2005. The ProjectServer_Archive,
ProjectServer_Draft, ProjectServer_Published, and
ProjectServer_Reporting were created in SQL 2000. I thought they were
supposed to be in SQL 2005. Two questions:

1. Does it matter if the databases are in SQL 2000 or SQL 2005?
2. How would I re-create the databases in SQL 2005?

This is a test installation, so it does not matter if I have to create
brand new empty databases.

Thanks!

 

[Paul Conroy]

Your running SQL2005 under a named instance, so when you reference it in the
install procedure you should use the syntax {servername/instancename}.
SQL2000 will be the default instance so can be reference using {servername}.

PS2007 is fully supported on SQL 2000, however there are some
functional/performance benefits in using SQL 2005.

If you want to move to the SQL 2005 instance, you could either perform a
re-install or backup/restore across the instances and use the STSADM command
to update the farm. I strongly suggest the former.

 

[Andy S]

Thanks! I ended up creating a new PWA site and built those databases
on SQL 2005. I'm used to the editsite tool from 2003, so I didn't
know where to specifiy the databases for 2007.