Database Backup Compression Feature In SQL Server 2008


March 25, 2009

Introduction

Database Backup Compression was one of the most awaited features by Database Administrators in SQL Server 2008. Currently, this feature is only available in SQL Server 2008 Enterprise and Developer Editions. Databases which are backed up using database compression feature can be restored on all SQL Server 2008 editions. By default, this feature is turned off at the SQL Server Instance level.

"This article has a total of 3 pages including this page. Click the links below to open all 3 pages in a seperate window to learn Database Backup Compression Feature in SQL Server. Page 1, Page 2, Page 3"

Configuring Database Backup Compression Feature

Database Administrators can configure database backup compression feature of SQL Server 2008 at SQL Server instance level in the below mentioned two ways.

Configure Database Backup Compression Feature Using SQL Server Management Studio
Configure Database Backup Compression Feature Using TSQL

You need to be a member of serveradmin or sysadmin fixed server role to configure database backup compression at SQL Server Instance Level.



Configure Database Backup Compression Feature Using SQL Server Management Studio (SSMS)

  1. 1. Once you are connected to SQL Server 2008 Instance, right click the server and select properties.

    2. In the Server Properties Page, click on Database Settings node which is available on the left panel.

    3. On the right side panel, under Backup and restore you will be able to see a check box named compress backup.


    • When compress backup checkbox is unchecked then it means database backup compression is not enabled at SQL Server Instance level.
    • When compress backup checkbox is checked then it means database backup compression is enabled at SQL Server Instance level.

Click on Next Page to continue reading rest of the article…

Next Page..

Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect you privacy and you can unsubscribe at any time."