Do the MSPS 2007 Reporting DataBase or Published databases archive/preserve the deleted tasks, assignments, time-phased assignment data in any of their tables? If yes, what table(s) keep the the deleted records?
Yes and no - we keep a skeleton of the deleted objects in the _SHADOW tables (for those entities that we incrementally sync), however this is just enough to allow the cache coherency routines in the Pub Db, RDB and Pro client to identify data to be deleted (and to stop it coming back).
If you want to keep a richer cache I suggest using the Reporting store and its events to copy data as it arrives and then to then look for and tag deletes (by the disappearence of data) - this is fairly simple to do with a couple of caveats in that you should use the USERVIEWS views to reference the custom field data as there are situations where we can rebuild the underlying custom field column pools that would complicate custom field caching.
Where do deleted tasks go in the MSPS 2007 Reporting Database?
