• The only way to know how much compression you would actually get is to actually try it on your data.

    Install SQL 2008 developer somewhere

    Import a sample of your largest tables into the 2008 database, use sp_estimate_data_compression_savings to check the compression you would actually get.

    In my environment PAGE compression compressed my data with over 70%.

    /SG