How do you copy or clone a project server database?

Bob · Oct 28, 2004

I have a project server up and running.

I would like to create a copy of the project server database on another
machine in my lab.

I can use SQL backup and restore to move the data. But how do I get the
project server in my lab to recognize the new database?

Can anyone suggest a way to do this?

Bob Segrest

Dale Howard [MVP] · Oct 28, 2004

Bob --

Restore the backed up copy to a new database on the other server. Then use
the EditSite utility to create a new Project Server instance. Download the
EditSite utility at the following link:

http://www.microsoft.com/downloads/...3e-54e1-40a9-9bb8-2dd293226b6f&DisplayLang=en

Hope this helps.

How do you copy or clone a project server database?

Bob

Dale Howard [MVP]