Post reply

Full and Differential backup size is same ??.

  • October 6, 2020 at 11:33 am

    #3793134

    I know this is an old thread but I've just encountered the same issue.

    Someone had used a Maintenance Plan to backup the databases, Full at midnight and Differential every 4 hours during the day.

    Both backup files were the same size, actually the Diff was a little bigger and growing.

    Running an independent backup of each type showed the Full was big and the Diff was tiny, as I had expected.

    Whilst this might not be the problem you are encountering, it is worth checking this....

    When I looked more closely at how the Maintenance Plan had been set up I could see the Diff Backup was only that in Name and it was actually defined as a Full backup.

    Screenshot 2020-10-06 122939

     

  • October 6, 2020 at 12:02 pm

    #3793141

    Good catch.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA     Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 2 posts - 16 through 16 (of 16 total)

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