-
Recent Posts
Recent Comments
- steve kirchner on Whats a Good Rule for Max Degree of Parallelism?
- Bipin on Stored Procedure to Sequentially Run SQL Agent Jobs
- Bipin on Stored Procedure to Sequentially Run SQL Agent Jobs
- tim cronin on A Busy/Accidental DBA’s Guide to Managing VLFs
- Automated fix for a high VLF Count – pagesql on A Busy/Accidental DBA’s Guide to Managing VLFs
Archives
Categories
Meta
Category Archives: Backup
Why Do My SQL 2008 Compressed Backups Shrink?
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing they noticed that the backup file shrunk rather than grew. It turns out this behavior is intentional and beneficial. Continue reading