configure-backup-compression-sql-server.md

title	Configure Backup Compression (SQL Server) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	dbe-backup-restore
ms.tgt_pltfrm
ms.topic	article
ms.assetid	430905eb-d218-458c-bd48-aeee6fbb7446
caps.latest.revision	7
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

Configure Backup Compression (SQL Server)

At installation, backup compression is off by default. The default behavior for backup compression is defined by the backup compression default Option server-level configuration option. However, you can override the server-level default when creating a single backup or scheduling a series of routine backups. To change the server-level default, see View or Configure the backup compression default Server Configuration Option.

Override the Backup Compression Default

You can change the backup compression behavior for an individual backup, backup job, or log shipping configuration.

• [!INCLUDEtsql]

  To override the server backup-compression default when creating a backup, use either WITH NO_COMPRESSION or WITH COMPRESSION in you BACKUP statement.

  For a log shipping configuration, you can control the backup compression behavior of log backups by using sp_add_log_shipping_primary_databasesp_change_log_shipping_primary_database (Transact-SQL).

• [!INCLUDEssManStudioFull]

  For information about how to view or configure the backup compression default option for an instance of [!INCLUDEssNoVersion], see View or Configure the backup compression default Server Configuration Option.

  You can override the server backup-compression default when creating a backup by specifying Compress backup or Do not compress backup in any of the following dialog boxes:

  • Back Up Database (Options Page)

    When backing up a database, you can control backup compression for an individual database, file, or log backup.

  • Use the Maintenance Plan Wizard

    The Maintenance Plan Wizard enables you to control backup compression for each set full or differential database backups or log backups that you schedule.

  • Integration Services (SSIS) Back Up Database task

    You can control the backup compression behavior when creating a package for backing up a single database or multiple databases.

  • Log Shipping Transaction Log Backup Settings

    You can control the backup compression behavior of log backups.

See Also

Backup Compression (SQL Server)