SQL Server Backup Tuning and Configuration

[@mubashir3]

I used to have backup compression turned on. However, the built-in compression appears to not be very good. I found that if turned off the built-in compression and then used 7-zip to compress the backup after, I got a much smaller file in the end. Much easier to copy off to a remote location.

[@KevinFeasel]

That's a good point that I didn't touch upon in the video: how to get the smallest possible backup. The goal in the video was "How do we reduce how long this backup takes?" versus "How do I store backups long-term for the least amount of money or move them to remote storage the fastest?" There is, as you note, some tension in answering those two questions.