SQL Server Backup Compression [18+]

By: Screen Rant

16 views

Uploaded on June 28, 2010 by DBATAG Powered by YouTube

Detailed Article for "SQL Server Backup Compression" is available at :

http://sqlserver-training.com/backup-compression-sql-server-2008

Follow us at more Updates at
-----------------------------------------
Website : http://sqlserver-training.com/
Twitter : http://twitter.com/dbatag/
Facebook : http://facebook.com/dbatag/
Linked In : http://in.linkedin.com/in/dbatag/

============================



Backup compression was introduced in SQL Server 2008 Enterprise, which reduces the size of backups and the time that it takes to create them.

Using backup compression is a simple process. Transact-SQL—WITH COMPRESSION in the BACKUP statement,


BACKUP DATABASE AdventureWorks2008
TO DISK = 'C:\AWBackupCompressed.bak' WITH COMPRESSION

By default, no backups are compressed. You can change this default setting by using sp_configure to set the value of the backup_compression_default setting as shown in the following code example. Alternatively, you can change the default setting by selecting the option in the Server Properties dialog box.

USE master
Go
EXEC sys.sp_configure N'backup compression default', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO

Although compressed backups require less disk space to store them and less time to create, there is a tradeoff. The compression is a CPU-intensive operation that can impact other operations that occur on your servers. To avoid such contention, you can use Resource Governor to limit the CPU usage for a backup operation.

Note:

Compression and transparent data encryption are mutually exclusive.
Creating a backup with compression is supported only in SQL Server 2008 Enterprise Edition; all SQL Server 2008 editions can restore a compressed backup.


Visit the following link for more details and SQL Server Tutorials

http://sqlserver-training.com/
http://sqlserver-training.com/how-many-dmv-are-available-in-sql-server-2008
http://sqlserver-training.com/how-to-move-tempdb-files-to-a-new-drive-video
http://sqlserver-training.com/featured-articles
http://sqlserver-training.com/complete-list-of-sql-server-versions-builds
http://sqlserver-training.com/cumulative-update-package-3-for-sql-server-2008-r2-is-released-now
http://sqlserver-training.com/video-tutorials
http://sqlserver-training.com/how-to-optimizing-tempdb
http://sqlserver-training.com/dbcc-check-db-uses-parallelism-how-it-works
http://sqlserver-training.com/sql-server-2008-upgrade-tools-and-approaches
http://sqlserver-training.com/migrating-sql-server-2000-to-sql-server-2008
http://sqlserver-training.com/new-features-of-sql-server-2008-2
http://sqlserver-training.com/extensible-key-management-ekm-sql-server-2008
http://sqlserver-training.com/database-mirroring-enhancements-in-sql-server-2008-from-2005/
http://sqlserver-training.com/data-compression-table-level-compression-video-tutorials/
http://sqlserver-training.com/sql-server-2008-hot-add-cpu/
http://sqlserver-training.com/sql-server-migration-assistant-for-mysql/
http://sqlserver-training.com/microsoft-sql-server-migration-assistant-for-sybase/
http://sqlserver-training.com/sql-server-migration-assistant-for-oracle/
http://sqlserver-training.com/sql-server-migration-assistant-for-access/
http://sqlserver-training.com/database-size-growth-chart-report-graphically/
http://sqlserver-training.com/introduction-to-microsoft-sql-server-2008-r2/
http://sqlserver-training.com/sql-server-2008-workshop-in-chennai-august-02-to-august-05-2010/
http://sqlserver-training.com/new-features-of-sql-server-2008/
http://sqlserver-training.com/sql-server-2008-star-join-query-optimization/
http://sqlserver-training.com/sql-server-monitoring-management-pack-6-1-314-36/
http://sqlserver-training.com/sql-azure-database-video-tutorial/
http://sqlserver-training.com/can-we-call-dll-from-sql-server/
http://sqlserver-training.com/master-data-services-mds-sql-server-2008-video-tutorial/

Tags:
Backup Compression, SQL Server Backup Compression, Compression, Shrink The Backup Size, Reduce Sql Server Backup Size, Sql Server Backup Shrink, Sql Server Small Backup, Sql Server Reduce Backup Size, People & Stories

ALSO FROM THIS CHANNEL

Comments on SQL Server Backup Compression

RECOMMENDED CHANNELS