Solved

Move Project Server 2007 Databases to Different Server

Posted on 2010-11-22
3
748 Views
Last Modified: 2013-11-15
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
0
Comment
Question by:allan_jardine
  • 2
3 Comments
 
LVL 35

Expert Comment

by:Bembi
ID: 34220164
0
 
LVL 5

Accepted Solution

by:
allan_jardine earned 0 total points
ID: 34228813
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
0
 
LVL 5

Author Closing Comment

by:allan_jardine
ID: 34272634
this was the simplest method of moving the databases to a new server
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now