Benefits of Backup Compression – Faster BACKUP / RECOVERY

  This is in continuation to my blog that I posted on 23rd Dec, 2008 on “SQL Server 2008 Backup Compression”. While discussing about Benefits of SQL Server Backup Compression, I talked about “Faster Database Recoveries from Compressed Backups”. This might have raised questions “How do we achieve faster recoveries from compressed backup sets, when…

1

How to identify weather a Database Backup Set was compressed using WITH COMPRESSION

This is in continuation with my first blog “SQL Server 2008 Backup Compression”. I received this query from one of the reader about “How to determine, if a Database Backup set was compressed using WITH COMPRESSION”. A simple way to identify this to use RESTORE HEADERONLY. RESTORE HEADERONLY command can be used to fetch all…

1

SQL Server 2008 Backup Compression

I’m still in process to make myself familiar with latest SQL Server release i.e. SQL Server 2008. To begin with, I concerted on new features/enhancements related to database administration and came across with this interesting new feature – SQL Server 2008 Backup Compression. In the past few years, there has been a tremendous growth in…

4