Using Backup Compression in SQL Server

Backup compression may not sound exciting, but it easily reduce the space you need for backups by 50% or more. If you look at the cost of storage that's interesting by itself, and being able to keep two days on disk instead of one is always attractive to a DBA. It's easy to use, effective, but not without a cost of its own in licensing.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Robert Wine on 2/2/2011

Some of your videos are difficult to hear while others are excellent. Not sure why, but some just come in louder than others. Great stuff though guys, keep up the great work.

Maurice Ivory on 2/2/2011

This is very great!!

melissa on 2/2/2011

What are the disadvantages, if any, of using compression with backups?

Chris on 2/2/2011

Sound was very low, but the presentation was great.

Satyabodhi Densmore on 2/2/2011

EXEC sp_configure ‘backup compression default’, '1'; RECONFIGURE WITH OVERRIDE;

Shellz on 2/2/2011

Always a great video!

manjeet on 2/2/2011

good for dba

zahid on 2/2/2011

very good for knowledge...thanks

sunil reddy on 2/3/2011

Good vedio..

Venkat budati on 2/3/2011

this video i use full for me time save and easy process

Steve Harris on 2/3/2011

Does this have any impact when restoring the backup?

Raymond on 2/3/2011

I always learn something new. Thanks Andy.

D151BB6B9F on 2/4/2011

Would have been nice if you mentioned if there's anything special about restoring a compressed backup.

Andy Jarman on 2/6/2011

SQL 2008 R2 supports compression in the standard edition as well....

mark mcnary on 2/11/2011

too bad it's only in enterprise.

lital on 2/14/2011

more videos regarding compression will be great

Murali on 2/16/2011

it is really good. restoring the compressed backup file....is it same as general restore process.

sarmadh on 4/15/2011

thQ

Anil Babu on 6/18/2011

ty

Jerry Stretch on 7/6/2011

Well done.