Tag Archives: Backup Compression

Backup Compression – SQL Server 2008 (Video Tutorial)

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 [...]