Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
Course Of The Month
11 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Move Project Server 2007 Databases to Different Server
Posted on 2010-11-22
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
ProjectServer_Archive
ProjectServer_Draft
ProjectServer_Published
ProjectServer_Reporting
Proj_SSP
PWA_Content
PWA_SSP_Content
SharePoint_AdminContent
SharePoint_Config
WSS_Search_AWPROJECT
[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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Summary
In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 11 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
Earn Certification
MTA - Cloud Fundamentals - 98-369
$59.00$53.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.