Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kevin van der Merwe SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times) RE: SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times)

  • March 13, 2009 at 8:27 pm

    #959604

    I noticed that during SQL2008 backup with compression, the backup file size is doubled until the backup is completed. For example, a database sized 10 GB with the final backup file 2 GB, the actual size (space used) during the backup is 4 GB.

    This means we need double the space for the backup operation.

    Does anyone experience the same? What is the story behind?