-
StatPress TopPosts
Recent Posts
Recent Comments
- admin on Stored Procedure to Sequentially Run SQL Agent Jobs
- admin on A Busy/Accidental DBA’s Guide to Managing VLFs
- How many temp database files ? | nguyennp's blog on Script to Create A TempDB File Per Processor
- georg9 on Stored Procedure to Sequentially Run SQL Agent Jobs
- Tony Santangelo 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