• Most of the backups I've seen have had somewhere between 50-80% size reduction. That's just ballpark possible numbers though, as Jeff said, it depends on the Data.

    The live data... I wouldn't even throw out a guess. If you have a sql 2008 developer or enterprise install to play with, you can use this script by Paul Nielsen to estimate the compression savings for your database.

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]