2008 Enterprise Backup With Compression 1

[JohnBates]

hi all,

I'm experimenting with the Compression feature in 2008 Enterprise. My 20 GB database backs up to a 3.4 GB .bak file when I specify With Compression.

That's about 1/5 the original size. Articles I read said to expect about a 1 to 3 ratio.

**Will the size of the compressed backup file vary depending on things such as Fill-factor, etc or other factors?

I'm really pleased with the results and the fact that compression also completes in less time.

Thanks, John

 

[mrdenny]

The backup ratio will depend on the data in the tables, the compression options that you select umong other factors.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog