+ Reply to Thread
Results 1 to 3 of 3

Why would backup file size double overnight?

  1. Why would backup file size double overnight?

    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?


  2. Re: 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



  3. Re: Why would backup file size double overnight?

    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.


+ Reply to Thread