What is the purpose of the Proj Serv 2007 Shadow Databases?

A

Andy S

I see Project Server 2007 has shadow databases, which appear to
capture items that have been deleted. However, it does not appear to
store all the data that was associated with the item prior to
deletion. For example, once a task is deleted, it is moved to the
MSP_TASKS_SHADOW database, but the only pieces of information stored
there are TASK_UID, PROJ_UID, DELETED_REV_COUNTER, and DELETED_DATE.

What would be the purpose of keeping this data? It's not like I can
restore with it --- the task name (and all other bits of info
associated with the task) appear to be deleted.
 
P

Paul Conroy

Andy,

This is only my guess, and I would welcome anyone else's opinion.

It would make sense to keep a record of deleted tasks in order to reconcile
data previsouly stored in the client side cache.

Scenario:

PM1 Creates and Publishes a project.

PM2 Opens Project in Proj Pro then exits (stores project in cache)

PM1 Deletes a task and republishes project.

PM2 Opens Project (from cache which includes task PM1 has just deleted).
Proj Pro would need to validate whether this task is authorative. Without an
entry in the DB it could be assumed that it's a new task and in publishing
would undo the changes made by PM1. With the shadow tables containg a
history of deleted data, it provides the app with the ability to validate
which piece of data is authorative.

HTH

Paul
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com
 
Top