DPM 2012 SP1 environment.

I've noticed that our DPMDB size reached 40GB (plus 15GB log), which seemed bit high (personal feeling, not based on any data), so I've checked table sizes and sorted them by the space used and the 2 largest tables are tbl_TE_TaskTrail (~18GB) and tbl_RM_RecoverySource (14GB).

What exactly is contained in these DBs and are their sizes normal (as in proportional to the overall DB size)?

• Edited by MarkosP Friday, February 27, 2015 9:59 AM

No Sharepoint. I should've mentioned that in my post, I know that's a common source of large DPMDB size.

• Edited by MarkosP Friday, February 27, 2015 11:50 AM

Thanks for the hints, unfortunately none of those threads provide a definitive fix/answer.

However, I've checked the stored procedures and noticed that our DPMDB doesn't contain prc_TE_GarbageCollect stored proc. at all. I guess that might be the reason why the tasktrail table is so large. I've also checked on another DPM server we have and this sproc isn't there either.

As for the RecoverySource table, it seems the garbage collector isn't running either (or is missing) since the number of lines where IsValid = 0 is almost 490k (from total of 520k) lines.

• Edited by MarkosP Friday, February 27, 2015 2:26 PM

Mike, I've tried running the job manually using your instructions, then waited (actually 1hr) and checked msdpmcurr.errlog for the string, but there's nothing.

Also, the agent job completed in like 5s, not sure if that's correct behavior.

Job history shows previous runs from last 5 days, the job always ran at midnight and never took longer than 9s to run.

• Edited by MarkosP Wednesday, April 08, 2015 10:11 AM