Full and Differential backup size is same ??.

  • 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


  • 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