October 6, 2020 at 11:33 am
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.
October 6, 2020 at 12:02 pm
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