-
Recent Posts
Recent Comments
- Update Statistics fails with Error Number:–1073548784 “Could not allocate space for object ‘dbo.SORT” – ReplTalk on Stored Procedure to Sequentially Run SQL Agent Jobs
- 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
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