Results 1 to 4 of 4

Thread: compress backup file

  1. #1
    Join Date
    Jul 2015
    Posts
    2

    compress backup file

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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Sql2k8r2 backup has compression option builtin.

  3. #3
    Join Date
    Jul 2015
    Posts
    2
    Quote Originally Posted by rmiao View Post
    Sql2k8r2 backup has compression option builtin.
    And how to use this option?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    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
  •