Search This Blog

SQL Server 2008 Top New Features :Backup Compression

Backup compression enables the backup of a database to be compressed without having to compress the database itself. All backup types, including log backups, are supported and data is automatically uncompressed upon restore.
  • Save storage space

  • Compressed backups can be stored on tape or on disk

  • Simple configuration using SQL Server Management Studio

  • Default state of all backups on a server to be compressed can be configured