Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Did you know? SQL Server 2008 includes Backup Compression

Posted by denglishbi on June 5, 2008

SQL Server 2008 includes database Backup Compression:

Keeping disk-based backups online is expensive and time-consuming. With SQL Server 2008 backup compression, less storage is required to keep backups online, and backups run significantly faster since less disk I/O is required.

By default, backup compression significantly increases CPU usage, which can adversely impact concurrent operations. You can now create low-priority compressed backups in a session whose CPU usage is limited by Resource Governor.

SQL Server 2008 Developer and Enterprise Editions and later supports compressing backups, and every edition of SQL Server 2008 or later can restore a compressed backup.  

· Check out a screencast about the new Backup Compression feature in SQL Server 2008 here.

· Read more about this in the SQL Server 2008 BOL ‘Backup Compression (SQL Server)’.

Did you know? SQL Server 2008 includes Backup Compression from Dan English on Vimeo.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: