Backup Compression in SQL Server 2008
Backup Compression in SQL Server 2008 is really a amazing feature. Earlier we used to use litespeed to compress the backup. As we are dealing with the backups that are in 2 GB to 1 TB in size , to move the bkps to remote machines the bkp should be compressed.
Hence this feature is really saving the Size and Time also. I wondered to see it is also reducing the time also.
I just tested this feature for a small database ,”Optim_Test1″ on my local machine.
Performed the backup with No Compression
Backup Compression in SQL Server 2008:
From the above screens you might have observed that the option WITH COMPRESSION has been showing differences in both Time and Size.