I am trying to clear up an ugly maintenance plan on SharePoint databases that happen to also be backed up by Data Protection Manager (which is setup to take snapshots at 15-minute intervals). The business would like to separately perform backups of the content using the built-in SQL tools. Will performing database backups, transaction log backups, and/or transaction log truncation within SQL Management Studio interfere with the DPM backups/restores?
Sql-server – SharePoint – Do DPM and SQL backups affect each other
backupbackup-restorationscdpmsharepointsql server
Best Answer
You'll be absolutely fine doing this. DPM uses the VSS mechanism for performing backups, which does not interact with the native LSN-based backup mechanisms. The only thing to be wary of is that if you switch into the FULL recovery model, the first VSS-based full database backup will do the same as the first full native database backup - and properly switch the database into the FULL recovery model, where log backups are required to manage the size of the transaction log.
With DPM backups, if you're in the FULL recovery model, you must also take log backups otherwise the transaction log will grow forever. The alternative is to use the SIMPLE recovery model where log backups are not required and the transaction log will truncate on checkpoint.
So, you are absolutely safe with the plan you describe.