Hi my Database "mdf" file of DPM is getting very large 190 GB and below the tables size, any recommendation ?

version of DPM 2012 R2 CU2

Hi,

Getting huge sizes for the DPMDB is normal if you are protecting large SharePoint farms and have many recovery points. The big table (SharePointRecoverableObject) stores all the recoverable items (thus going up to list item level) of every recovery point, so just do the math with your farm.

In my opinion, if the rest of the tables do not grow in an anomalous way, there is no real problem (except that you will need to add more storage, probably).

According to This technet article , it is a good practice to rebuild or reorganize the indexes on that table from time to time, in order to speed content searches. This could also save some space.

hth

Roberto

• Edited by Roberto MD Wednesday, January 21, 2015 9:44 AM

For this issue, you can refer below links

http://scug.be/valerie/2012/11/20/dpm-2012-cu3-large-dpmdb/

https://social.technet.microsoft.com/Forums/en-US/e0e70be6-7249-438d-b43c-a0456f7c1338/dpmdb-database-and-log-file-dpm-2012-get-very-big-with-lots-of-free-space-in-just-one-day