Why would backup file size double overnight?

wrote in message
news:1173293884.960071.224960@8g2000cwh.googlegroups.com...
> SQL 2005 cluster, one database, full backup to disk every night. .BAK
> file size had been in the 10 GB range, until one night when I
> intentionally failed the cluster over and back (installing security
> updates). Ever since then, the size of the .BAK file has doubled in
> size.
>
> If I check the size of the actual database, it is still about 7 GB in
> size. Any ideas why the backup file grew so large?
>

Database get set to SIMPLE RECOVERY?

Or a DBCC DBREINDEX or something done?


--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

On Mar 7, 2:21 pm, "Greg D. Moore \(Strider\)"
wrote:

> Database get set to SIMPLE RECOVERY?
>
> Or a DBCC DBREINDEX or something done?
>
> --
> Greg Moore
> SQL Server DBA Consulting
> sql (at) greenms.com http://www.greenms.com

Nope, recovery model is still set to full. No reindexing or anything
done. Just rebooted. I'm going to test the restore of the larger
file to make sure it's not corrupted in any way, but I'm still at a
loss to understand how this could happen. Backup log shows nothing
other than the fact that it took twice as long to complete.