I am trying to use Microsoft System Center Data Protection Manager (DPM) 2016 (5.0.342.0) to protect SQL Server 2017 Standard CU8 (14.0.3029.16) on Windows Server Std 2016. I have a named instance with the standard built-in databases (master, msdb, model) and a couple of custom databases that were created by doing a restore from a full backup of SQL Server 2012. I have switched the custom databases to partially contained and to database compatibility level 140. Their Recovery Model is Full. They are not in an Always-On Availability group, they are not configured for mirroring, they are not configured for transaction log shipping. When I set up a DPM protection group and choose the entire instance, then configure 15-minute synchronizations along with daily Express full backups, DPM sets up Recovery Point jobs (effectively, transaction log backups) every 15 minutes for model, but my custom databases only get jobs for the daily full-database backup. I can't find any specific error messages that seem relevant in Event logs (System or Application) on the DPM Server or the SQL Server, in the DPM logs (C:\Program Files\Microsoft Data Protection Manager\DPM\Temp) on the DPM server or the SQL Server, or in SQL Server's own error log. I've granted both the DPM Server's domain computer account and the local account running the DPM agent (NT Service\DPMRA) a local user in the custom database with the db_owner role, but that doesn't help. Any suggestions? thanks! Martin

Deleted a defunct database in SharePoint, now getting alerts from DPM saying: The following alert occurred at 2/16/2016 12:16:54 PM. Status: Active Data source type: Data source: SharePointServer\Database_I_Just_Deleted Computer: SharePointServer Description: Last 1 recovery points not created. For more information, open DPM Administrator Console and review the alert details in the Monitoring task area. ---- Cannot find where to disable monitoring of this deleted database.

I'm trying to backup my availability group in SQL Server 2016 using DPM 2016, but after I add the cluster in DPM, availability group show nothing to back up. I've set every secondary node to be readable secondary and add sysadmin role to \SYSTEM user. How can I fix this?

Our server team has implemented System Center Data Protection Manager (DPM). It was decided that some of our non-production database servers would be backed up using DPM. After researching this, it seems that Microsoft recommends adding the account that the DPM service runs under to the SQL sysadmin role. Yikes! Does anybody know what DPM is doing in SQL Server? Can I just give the account only certain permissions to do its job?

I'm trying to set up the database maintenance solution for SQL Server 2014 using this SQL script and System Center Data Protection Manager 2012 r2 as a BackupSoftware (like SQLSAFE, SQLBACKUP and SQLSAFE) 1. Does anyone now which DPM backup procedures are needed to be called directly from SQL Server Management Studio to backup a database? 2. Is there any other way how to backup sql server 2014 databases using DPM? Cmdlets? Thank you for any help!