[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

DPM error

We are using Data Protectin Manager (DPM) to protect SQL Servers. Now you all know that DPM will take backups every 15 minutes. Now I have a SQL instance and DPM is taking backups every15 minutes. in that instalce i have 4 databases. now since DPM takes backups very 15 minutes of all the databases together, one or two of the backups fails all the time since DPM starts the backups alltogether. so any idea how can i change the scheduled time for all the databases so that the backup time does not conflict with the other database.
  • 2
1 Solution
you can change the sync time to 30 minutes quite easy if you modify the protection group its on about the 4th / 5th page after you select "i want short term protection to disk"

If the reason that it failed was because the sync of all 4 databases took longer than 15 minutes this would sort that issue.
also if you want them to start at different points you could create 2 different protection groups

you could set them both to sync every 30 mins in 1 Protection group put 2 dbs and 2 in the other

then right click 1 of the protection groups and click on "optimize performance" and under the offset time set it to 15 minutes offset

this 1 1 syncs at 30 and 0 and the other will sync at 15 and 45.
espanolanthonyAuthor Commented:

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now