Where is the Administrative Backup

R

Robert

Hello,
Following a lot of problems, I have to reinstall Project Server 2007 but I
want to keep the Enterprise Resource Pool.
I expect to run an Administrative Backup on Enterpise Resource Pool and
Calendars but I'm not sure how to get it for the Restore in the new install.
Any advice?
Thanks in advance
 
B

Ben Howard

Hi Robert, the admin backup is kept in the archive database. You could just
restore the archive DB over the one in the new instance. If the reason for
the rebuild was down to software/hardware rather than configuration, then you
can restore the DBs to SQL server, and then when you create the new PS
instance you can just type in the names of the existing databases.
 
R

Robert

Thanks a lot Ben!

Robert

Ben Howard said:
Hi Robert, the admin backup is kept in the archive database. You could
just
restore the archive DB over the one in the new instance. If the reason
for
the rebuild was down to software/hardware rather than configuration, then
you
can restore the DBs to SQL server, and then when you create the new PS
instance you can just type in the names of the existing databases.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/
Click to expand...
 
R

Robert

Another question Ben:

While the Administrative Backup is working via a queueing process, how to
check that it is really done ?

Thanks again
 
B

Ben Howard

Fours ways of checking.
1. Check the queue job finishes successfully,
2. Click on Restore from Admin backup and check the data is there
(certainly you can do this for projects
3. Use SQL Manager to view the data.
4. Restore the Archive DB to a test instance.
 
R

Robert

Thanks four more times Ben!

Ben Howard said:
Fours ways of checking.
1. Check the queue job finishes successfully,
2. Click on Restore from Admin backup and check the data is there
(certainly you can do this for projects
3. Use SQL Manager to view the data.
4. Restore the Archive DB to a test instance.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/
Click to expand...
 

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

administrative restore 2007 urgent 1
ProjectServer2003/PWA2003 - Changing Project Ownership 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
2007 Administrative Backup / Restore 1
Administrative Restore... is there a bug? 2
Resource plans disappear when restoring projects/proposals from ba 3
Resource plan gone and disabled after administrative restore 0
removing inactive resources from the enterprise resource pool 1

Top