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)

  • May 5, 2008 at 4:55 am

    #810575

    Hi

    The "uncompress" actually happens inside the SQL Engine - so no additional space is required for a "temp" file. The only space required is the size of the Database and Transaction Log.

    Note: If a backup file is 900MB - the actual size of the database Data file is 3.5GB and the Log 100MB - then this is the amount of space required on disk for the restored Database files (Data and Log)

    Thanks

    Kevin