SQL Server 2000 Backup File Size is Excessive
Posted on 2009-04-19
When applying changes to our web site's database, I make a backup first in case I need to roll back the changes. The database is at about 5.5 Gb in size. Until now, my manual backups have always created a backup file sized about 75 Mb. There is also a daily job which creates the backup around midnight each day and that backup file is also about 75 Mb.
But tonight, for some reason, the manual backup I generated came out to about 5 Gb in size. This took that drive to less than 5% free disk space which is how I found out about the problem.
As far as I know I created the manual backup the same as always. I verify upon completion, overwrite existing media, and save to a new disk file. I'm wondering if I did append instead of overwrite or forgot to remove the existing filename when entering the new one. Even so, I would only expect a doubling of the file size, not the full database sizing.
Can someone explain or guess at what I did or what could have happened? Thanks.