Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Differential Backup Prediction Expand / Collapse
Author
Message
Posted Saturday, February 18, 2006 9:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 21, 2009 7:53 AM
Points: 26, Visits: 4
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dhatheway/differentialbackupprediction.asp


Post #259698
Posted Monday, March 13, 2006 1:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 3:06 PM
Points: 42, Visits: 24

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 




Post #265364
Posted Friday, September 14, 2007 12:44 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 28, 2014 5:19 PM
Points: 89, Visits: 1,051

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

Thanks,

Chad




Post #399425
Posted Friday, September 18, 2009 6:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 22, 2010 12:06 PM
Points: 14, Visits: 110
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
Post #790737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse