This is a step-by-step tutorial on how to backup the Tail of the Transaction Log using the graphical interface of SSMS.
In order to find more information about the Tail of the Transaction Log, please read our article, which offers more details regarding this type of backup, here.
compression
How To Configure Backup Compression
Now that we have previously discussed about backup compression, it is time we offer details about how to configure compression for your backups.
Just as a short reminder, backup compression is a powerful feature offered by SQL Server (versions 2008 and newer) that allows you to shrink the amount of storage space used by your backup files while at the same time increasing the speed of recovery which goes hand in hand with lower CPU usage when restoring the database from your backup.
Backup Compression
Backup Compression is a feature of SQL Server versions 2008 and later (2008, 2008 R2, 2012) which offers you more benefits without any cost to your data or its integrity.
In spite of \having been through a data compression process, the compressed backup actually has a few advantages over regular backups.