-
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|