SQL Server Backup Compression
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/
Comments are closed.