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 6, 2008 at 6:00 am

    #811125

    Nik Southworth (5/6/2008)

    My Test Results.

    SQL 2008 w/ Compression

    Size: 3.39GB

    Time: 12 Mins

    CPU%: AVG 40%

    SQL 2008 wo/ Compression

    Size: 14.0GB

    Time: 21 Mins

    CPU%: AVG 30%

    Restore details to follow.

    Good findings. In terms of speed and size the difference is almost more than 50%. The more big the database the more difference will come I believe. But one thing what will be the compression rate of image field?