Back up and Restore in Project Server 2007

R

Robert

Is it possiable to just backup the SQL Server 2005 db's [archive, publishing,
reporting, draft] from Production and restore them in a Testing Instance to
db's [archiveT, publishingT, reportingT, draftT] to have a mirror image if
you will.
 
M

Mike Glen

Hi Robert,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP
 
G

Gérard Ducouret

Robert,

Yes, it is possible. You just have to change the name of the database in the
dialog box while doing the restore.
If you are doing this backup-restore very often, you could write a stored
procedure in SQL Server which will do that.

Gérard Ducouret
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Backup and Restore Project Server 2007 / SQL Server 2005 4
Prj Server Standalone Migration 3
Restoring Deleted Project in Project Server 2007 7
Restore Project Server 2007 Instance - Only SQL Backups 2
Project 2007 Server migration 2
Project Web Access Analysis Server settings changed 1
Edit Project Properties in Project Center after migration 1
Moving Project Server 2007 instances 0

Top