GilaMonster (3/9/2011)
Brandie Tarvin (3/9/2011)
It sounds like you're restoring from a compressed backup file.
Not necessarily (if so, that's very poor compression). Backups don't include free space in the data file, so they're often smaller than the mdf
The second point is taken, however, Litespeed has variable compression and can do "poor compression" if the settings are too low. I'm sure other tools are the same.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.