DPM taking so long time to backup SQL Databases.
Hi Folks

I am facing an issue with backing up one SQL server. We have one application deployed for 2 different customers and I am backing up these 2 databases server in same protection group. 

Customer A's Database server is very busy because they upload heavy files into application which mackes databases busy continously. 
Customer B's Database server isn't much more activ e but is been in general use since they are uploading small and average files. 

Now when DPM backing up this protection group, Database B server is backing up normally. But Server A databases are taking longtime (15-18 Hours) to complete syncing and Backing up. 
This is excpected to take time since there are lot of changes in databases but not expecting such a long time where next scheduled backup jobs are overlapping with old ones. 

I just want to know How DPM track SQL changes on protected Server like through voume filter or bitmap? What precuation I should take to resolve this issue!

Here are few points related to these databases. 

1. Databases sizes are from 30 GB to 300 GB
2. These are Simple mode databases but files are spreaded through .ndf files. 
3. Application is loading heavy files interacting those databases. 
4. I have set Sync Frequency 4 hours and Express full backups 2 times in a day 10AM, 10PM
5. Support guys are taking manual backups randomly in .bak format. 

Also during DB backups, Sysem file is creating and growing upto 50-60 GB.




Please help on this. 
April 16th, 2015 6:25pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics