For my backup plan for SQL Server 2005, I want to do a full on Sunday:
BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_full.bak' WITH FORMAT GO
Then I want to do a differential nightly the rest of the week:
BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_Diff.bak' WITH DIFFERENTIAL GO
My assumption was that if there was little/no activity in the database, then the differential would not increase in size (or wouldn't increase by much).
However, when I run the differential backup above (with little or no activity), I'm seeing the differential backup increase by megs at a time. Why is it increasing like that?