Database Backup Compression Feature In SQL Server 2008
March 25, 2009
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. 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…
Continue Free Learning...