Solved

Move Project Server 2007 Databases to Different Server

Posted on 2010-11-22
3
751 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

756 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