Differential Backup Prediction

Question

Differential Backup Prediction

Darwin Hatheway

SSC Veteran

Points: 242
More actions
February 18, 2006 at 9:48 am

#189341

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dhatheway/differentialbackupprediction.asp

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Venkata Thiagarajan SSC Enthusiast Points: 162 More actions · Answer 1

Darwin,

Very nice article, good thinking there. This idea should be suggested to Microsoft as part of the Maintenance plan for application databases backup plan (with size as a criteria, my assumption this option is not there presently in the maintenance plan).

I appreciate the article and detailed analysis, thanks for the same.

Best Regards

TVN

Chad Carter Ten Centuries Points: 1089 More actions · Answer 2

Has anyone ever gone back and completed this to automate the process? I would be very interested in it.

Thanks,

Chad

dougznospam-mailbox Old Hand Points: 324 More actions · Answer 3

Thanks so much Darwin for explaining how to do this. Using your methodology I scripted this in two flavors. Even on very large databases (>1TB) it will complete in just a handful of seconds. Enjoy. 😀

T-SQL version: http://dougzuck.com/sql-differential-backup-size-prediction

Standalone HTML Application (HTA): http://dougzuck.com/hta