compress backup file

Hello, can you suggest an easy way to compress backup file. I use SQL Server 2008 R2

Sql2k8r2 backup has compression option builtin.

Quote:

---

Originally Posted by rmiao

Sql2k8r2 backup has compression option builtin.

---

And how to use this option?

backup database db_name to .... with compression

Or you can enable it server wide with following:

sp_configure 'backup compression default', 1
reconfigure