Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

SQL Server 2008 provides a feature, which, in my opinion, has been far overdue: backup compression. For too long, if you wanted the benefit of compressed backups, you had to look at a third-party tool ...

This article is a revised version of the original published January 3, 2005. See Editor’s Note for details. Two major factors drive database backups these days: compliance and disk space. Some ...

select top 20 database_name,str(backup_size/1024/1024/1024,10,2) as BackupSizeGB,str(compressed_backup_size/1024/1024/1024,10,2) as CompressedBackupSizeGB,backup ...

Your Microsoft SQL Server databases keep growing, but your storage hardware - and budget - aren't. You need a powerful, easy to use backup and recovery solution for SQL Server that gets the maximum, ...