By Steve Endow
I recently learned two interesting things about SQL Server backups from the esteemed Victoria Yudin
FIRST, I'm embarrassed to say that I didn't know that SQL Server 2008 added a native Backup Compression option. Admittedly, I'm not a full time SQL DBA and I don't spend much (any?) time on SQL maintenance or backups for the TWO databases on my development servers, but I probably should have picked up on the feature some time in the last SEVEN years, you would think.
Anyway, now that Victoria schooled me, I found that there are two places where you can set backup compression. The first is at the SQL Server instance level, under Properties -> Database Settings. Setting this option causes all database backups to compress by default.
The second location where you can select backup compression is under the database backup window on the Options page.
Here you can use the default server setting, or choose to manually enable to disable the backup compression.
I'm now going to enable the option for all of my SQL Servers.
Even if you didn't know about this option, if you have done SQL Server backups, you should already know that the SQL bak files are HIGHLY compressible. In my…