Data compression is a technique that reduces the amount of space required to store data in SQL Server. It can help you optimize the performance, scalability, and availability of your database, as ...

Backup Compression (SQL Server) [!INCLUDE SQL Server] This topic describes the compression of [!INCLUDE ssNoVersion] backups, including restrictions, performance trade-off of compressing backups, the ...

Now, backup compression is built right into SQL Server 2008, and what's even better is that it's easy to use. All you have to do is append the WITH COMPRESSION option to your backup statements and you ...