changing settings for a content database or Moving DB to other Ser

[Rully]

Good Afternoon,

How to change targer database server ms project.
if we want to move database project sql server to other server

please advise.

 

[Paul Conroy]

use the stsadm -updatepwainstance command
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

 

[Jesse Schuchart]

First backup and restore the dB's to the new dB server.

On the old server, open SharePoint Central Administration.
Click on the Shared Service for the site.
Click on Project Server Access Sites.
Click to the right of the project space to be moved, and click on edit.
There you will see the dB name (Primary database server: ) and the dB's for
the Project content. Put in the new dB name for the Primary database server,
and you are done.