I have a particular DB on a SS2005 Enterprise. It is scheduled to be backed up in FULL every day night @ 11 PM. And hourly tranlog backups are being taken between 6AM & 6PM. Every time a tranlog backup is taken old tran logs that are older than 24 hours are being cleaned up.
The database in FULL recovery model.
The Problem: The full backup size is 40 MB whereas tranlog backups are like 6GB, 9GB etc please look at the attached images.
Please advise, what is wrong here ?
Today is the tomorrow you worried about yesterday:-)