Backup Compression in SQL Server 2008

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

 

Backup Compression in SQL Server 2008:

 

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.

Posted in SQL Server DBA | Tagged , , , , | Leave a comment

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz