Backup compression is a very important feature introduced in SQL Server 2008. Using this technique, the daily backups from the server were compressed and lot of spaces were saved.
"Usually in production servers, DBA's /jobs will take the backup frequently. In least case, 1 backup per day. The file will be ended with *.bak". The size of the backup depends on the size of the database. To avoid more space for the backup's, Microsoft have introduced this backup compression technique." We will see more details on the new compression techniques in my future article.
Let's see how to enable the backup compression option in SQL Server.
USE master
GO
EXEC sp_configure 'backup compression default'
GO
EXEC sp_configure 'backup compression default', '1'
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'backup compression default'
GO
![]()
Cheers,Venkatesan Prabu .J
Head -
www.KaaShivinfotech.com
http://venkattechnicalblog.blogspot.com/