Hello, can you suggest an easy way to compress backup file. I use SQL Server 2008 R2
Printable View
Hello, can you suggest an easy way to compress backup file. I use SQL Server 2008 R2
Sql2k8r2 backup has compression option builtin.
backup database db_name to .... with compression
Or you can enable it server wide with following:
sp_configure 'backup compression default', 1
reconfigure