Restoring Databases in Project Server 2007

[Barbara G]

Hi,
I have both a production and test environment for Project Server 2007. My
data on the test environment was old so I wanted to have those databases
refreshed. After the databases were refreshed with current data from the
production environment, I cannot open up projects through Project Center or
Project Professional 2007. What is the best way to refresh databases?

Thanks,

 

[Gérard Ducouret]

Barabara,

I assume that you made a backup of the production DB, then a restore on the
Test DB
Did you check the option : Force restore over existing database.

and :

1.. Change the path the the files Data and Log
2.. Change the names of the files Data and Log
Gérard Ducouret

 

[Gary L. Chefetz]

Barbara:

Unfortunately, things aren't this simple in 2007. Brian Smith has an
excellent blog post on this subject. Look back a few months at the posts on:
http://blogs.msdn.com/brismith/default.aspx


--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com