How to transfer Project Server Database.

C

Claudio Hidetoshi

Hello,

I would like to know how can I transfer(migrate) Project
Server Database on SQL Server "A" to SQL Server "B",
maintaining all configurations. There are more resources
on SQL Server "B" than SQL Server "A"(memory, capacity,
processing).

Thanks,

Claudio Hidetoshi.
 
C

Claudio Hidetoshi

Hello Gary,

The mentioned article doesn't talk about database tranfer
for another SQL Server machine.

My doubt is: "What configuration type should be made in
Project Server machine, so that Project Server identifies
the new location of the database ?"

Thanks,

Claudio Hidetoshi.
 
G

Gary L. Chefetz [MVP]

Claudio:

Download the Site Editor tool to make the changes to your Project Server
configuration. The tool will change the necessary registry entries. The last
thing you need to do is make sure that the MSProjectUser and MSProjectServer
user accounts are specified correctly on the SQL server as logins and are
setup with the same password as contained in the Project Server registry.
 
Top