Post reply

Differential Backup size

  • December 15, 2015 at 2:42 pm

    #399477

    Hi -

    Is there a simple way to estimate the size of a differential backup (uncompressed)? I've checked out the script from P. Randall in 2008.

    Anything more recent?

  • December 15, 2015 at 2:45 pm

    #1846202

    it would really depend on the database. you'd want to keep track of the sizes some diff packups of the db over time for a while.

    if the database just receives occasional updates, vs lots of updates, vs a truncate and reload scenario, all will have different growth and size patterns.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 15, 2015 at 2:48 pm

    #1846203

    It's a very volatile OLTP environment, with many, many IUD's happening throughout the day.

    I'm trying to estimate (by executing a script, if one exists) that size of individual diff backups post full backup.

    Thanks in advance.

  • December 15, 2015 at 6:57 pm

    #1846231

    A simple way? None that I'm aware of.

    I did a search. The script documented here comes up pretty frequently, but it's anything but simple.

    Looking at Paul's script, I'm pretty sure it'll still work.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • December 16, 2015 at 9:42 pm

    #1846471

    take a look at this article: https://dougzuck.com/sql-differential-backup-size-prediction

  • December 17, 2015 at 5:24 am

    #1846523

    What's your exact use case for this? I can kinda see where it would be useful in some limited circumstances, but otherwise there's not much point.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • December 19, 2015 at 5:50 pm

    #1846953

    I could think of one way, but I wouldn't recommend it. Create snapshot of your database immediately after your full backup. Look at the file size using compact.exe. For example:

    compact.exe AdventureWorks_Snapshot.ss

Viewing 7 posts - 1 through 6 (of 6 total)

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