Experts Exchange connects you with the people and services you need so you can get back to work.

Move Project Server 2007 Databases to Different Server

I have a project server 2007 installation using a separate SQL005 database server. I want to move the databases to a new SQL2008R2 server but i am stuggling to find some simple instructions for this. The databases I need to move are:

ProjectServer_Archive
ProjectServer_Draft
ProjectServer_Published
ProjectServer_Reporting
Proj_SSP
PWA_Content
PWA_SSP_Content
SharePoint_AdminContent
SharePoint_Config
WSS_Search_AWPROJECT

allan_jardine

Asked: 2010-11-22

Advertise Here

1 Solution

LVL 35

BembiCEOCommented: 2010-11-26

Have a look here:
http://proj2007.blogspot.com/2008/10/steps-to-move-project-server-2007-from.html

LVL 5

allan_jardineAuthor Commented: 2010-11-29

Hi Bembi - thanks for the response but the article refers to moving from one environment to another and all i want to do is move the databases to a new server. I have achieved this in the end by setting a server alias using the SQL Client Network Utility CLICONFG

LVL 5

allan_jardineAuthor Commented: 2010-12-04

this was the simplest method of moving the databases to a new server

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Move Project Server 2007 Databases to Different Server

Join & Write a Comment Already a member? Login.

Featured Post