Full and Differential backup size is same ??.

  • giles.clapham

    SSCrazy

    Points: 2173

    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

     

  • Grant Fritchey

    SSC Guru

    Points: 396763

    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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

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

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