DPM backups not happening

[neonetman]

I've recently set up a new DPM server to backup file shares, SQL db's and HyperV VMs. All my protected items are showing as okay, however the backups are not occurring as per schedule (although if I create a recovery point manually that works).

 

I've already checked the SQL agent service is running, and have also removed and re-added the protection groups. I'm at a loss what is causing this, however I need to get to the bottom of it.

 

Can anyone suggest what is causing this?

 

Cheers

[Fazza]

DPM is simply a front-end to several programs so it doesn't actually perform any backups nor schedule the backups, DPM is more of an interface amalgamating things like Windows Server Backup and SQL together.

 

As I found out recently, just because DPM says everything is OK doesn't it is! A green tick doesnt mean everything is OK and being backed up, it just means nothing has gone wrong with the last thing that run and if nothing runs then it displays a green tick as it's not doing anything then nothing can go wrong! #MicrosoftLogic

 

 

SQL actually schedules the jobs and initiates the backups so you need to take a look at the SQL Server Agent Jobs in Microsoft SQL Server Management Studio and see if any of them are disabled or not:

 

 

To enable a disabled job simply right-click and select enable.

 

 

I had this issue the other day and for some reason, random jobs were disabled and enabling them made all my backups work again!

 

Good luck!

[neonetman]

I've got everything running now (after changing the SQL services to the local Microsoft DPM account) apart from the SQL backups (So file backups, Exchange databases and Hyper-V machines are now backing up correctly).

 

Any advice on troubleshooting why the SQL backups aren't running?

[Fazza]

I've got everything running now (after changing the SQL services to the local Microsoft DPM account) apart from the SQL backups (So file backups, Exchange databases and Hyper-V machines are now backing up correctly).

 

Any advice on troubleshooting why the SQL backups aren't running?

 

Have you done as I suggested above and gone in to the SQL Server Management Studio and looked a the SQL Server Agent Jobs to confirm none are disabled? In my screenshot the second one down is disabled - you will need all these jobs to be enabled for your backups to be running.

 

 

Once you've made sure all the jobs in SQL are enabled, at an elevated DPM Management Shell type DPMSYNC - SYNC and then see if your backups start running

[neonetman]

Have you done as I suggested above and gone in to the SQL Server Management Studio and looked a the SQL Server Agent Jobs to confirm none are disabled? In my screenshot the second one down is disabled - you will need all these jobs to be enabled for your backups to be running.

 

 

Once you've made sure all the jobs in SQL are enabled, at an elevated DPM Management Shell type DPMSYNC - SYNC and then see if your backups start running

 

Thank you - I'd missed that step, and we had many tasks disabled. Having enabled them and run the DPMSync, I've now waiting for it to sort itself out as just over half the backups are showing critical (replica inconsistent).

 

I'll feedback once it's had time to update

[neonetman]

Okay so I've come in this morning and checked the DPM server. Most of the backups are now running correctly, although a couple of databases on one server don't appear to be still running the scheduled backup (all the rest on the same server are fine)

 

UPDATE:-

 

It is only the "model" and "reportserver" databases on out main DB server that are backing up - the rest I've still got to do manually - could this be the account that SQL agent is running under?

Edited October 15, 2020 by neonetman