Recover Timesheets, Issue, Risks, Etc.

[dhrisd]

Could someone PLEASE explain to me how to recover a timesheet, issue/risk,
and attached documents from backup and how they will be reattached to a
project plan? Also am I correct in my understanding that all of these items
are stored in separate databases? Please advise. Thanks!!!

 

[Andrew Lavinsky]

All of these items (with the exception of the timesheet) are stored as content
in the workspace, which is generally in a content database with all of your
other workspaces.

In general, you need to restore the entire workspace, and then resync it
to the project. In specific, that depends on what happened that requires
a restore and how you backed up your data.

At its simplest, if the site still exists, you might be able to just dip
into the site recycle bin and restore it.

Perhaps you could provide us with details: What happened that you need to
restore, and how have you backed up your data?

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[dhrisd]

Thanks Andrew for replying. Actually we had to restore a corrupt project
plan. But a question came up about what would we do if we had to restore
timesheets, issues/risks, and attached documents since they are stored
separately. Which got me to thinking as well since it was such a chore to
restore the project plan, which we are still trying to get back to normal. So
what about the timesheets, how would those be restored? And how do you
resync?

 

[Andrew Lavinsky]

A couple of answers/questions there:

1) How are you restoring the project? The easiest is to just schedule an
Administrative Restore in Server Settings. Then you can set the number of
versions, and easily do an Administrative Restore again from Server Settings.

2) If you use that method, you don't have to sync the workspace again. Alternately,
restore the project using the method you appear to be using (I am not sure
how you're doing it), then go to Server Settings, Project Workspaces, select
the new/restored project, add the URL to the existing workspace, and select
sync.

3) If you had to restore the SharePoint Content DB, which includes the workspace
data, then you would simply restore that, and again sync to the project using
the method above. The easiest method to do that is to split out your PWA
from your workspace content databases. If you don't have good IT staff with
SharePoint experience, you might want to consider engaging a Microsoft partner
to review your current set up and make recommendations.

4) I am not sure what you mean by timesheets....are you talking about one
timesheet that was deleted - or all timesheets if the system goes down?
If your system crashes, you can restore the last version of the four Project
Server databases, provision a new PWA site, and get all of your data back,
including your timesheets. The workspaces are in the separate content database.

Not sure if that helps, but let me know if you have any questions.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[dhrisd]

This helps a bunch!!!! Thank you Andrew!

A couple of answers/questions there:

1) How are you restoring the project? The easiest is to just schedule an
Administrative Restore in Server Settings. Then you can set the number of
versions, and easily do an Administrative Restore again from Server Settings.

2) If you use that method, you don't have to sync the workspace again. Alternately,
restore the project using the method you appear to be using (I am not sure
how you're doing it), then go to Server Settings, Project Workspaces, select
the new/restored project, add the URL to the existing workspace, and select
sync.

3) If you had to restore the SharePoint Content DB, which includes the workspace
data, then you would simply restore that, and again sync to the project using
the method above. The easiest method to do that is to split out your PWA
from your workspace content databases. If you don't have good IT staff with
SharePoint experience, you might want to consider engaging a Microsoft partner
to review your current set up and make recommendations.

4) I am not sure what you mean by timesheets....are you talking about one
timesheet that was deleted - or all timesheets if the system goes down?
If your system crashes, you can restore the last version of the four Project
Server databases, provision a new PWA site, and get all of your data back,
including your timesheets. The workspaces are in the separate content database.

Not sure if that helps, but let me know if you have any questions.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm



.