Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2015
    Posts
    1

    Unanswered: compress backup file

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

  2. #2
    Join Date
    Jun 2015
    Posts
    2
    Backup compression is set off by default.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If you have Enterprise Edition, you just add COMPRESSION to the with clause:
    Code:
    backup database dbname to disk = 'somefile' with init, stats = 10, compression

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    ...or to compress backups for all databases by default you can execute:
    Code:
    EXECUTE sp_configure 'show', 1
    GO
    RECONFIGURE
    GO
    EXECUTE sp_configure 'backup compression', 1
    GO
    RECONFIGURE
    GO
    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •