Solved

Move Project Server 2007 Databases to Different Server

Posted on 2010-11-22
3
752 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 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