We are currently using Data protection manager 2012 SP1 to back up our medical records database in SQL Server 2008 R2.
The database server is running Windows Server 2008 R2 as a virtual machine with the VM host running Windows Server 2012.
The database files exist on a cluster shared volume connected to the VM. On the backend of the CSV, it connects using iSCSi to our Lefthand/HP SANs where the data is ultimately stored.
We recently installed DPM 2012 after having the server being backed up on DPM 2008.
The issue we are having is that each night the express full backups seem to continue to grow. The database, including log file, is around 400GB. 305GB of that is for the MDF specifically.
We have a nightly maintenance job running based on the hallengren sql scripts. This job currently only reorganizes or rebuilds the indexes that require it based on the default conditions of fragmentation in the script.
Auto-Update Statistics is also set to true for this database.
So, the problem is that our express full backups, that run once a night from DPM, seem to use an increasing amount of space. Sometimes this space is reduced, but several times it has been almost as large as the MDF file itself. So, something seems off here and I'm hoping you all can give me some ideas.
I will say that the amount of space, for our 30 day retention period, has stabilized after the past month and it does not seem to be asking for any more. We also grab recovery points every 15 minutes.
Thanks for any help you can offer.