Select a Country
White Papers
Microsoft SQL Server 2008 data and backup compression
Data compression of selected tables and indexes of a database and backup compression of database backups are two new features in Microsoft® SQL Server® 2008 database software that can be used in combination to reduce database and backup storage costs. Tables and indexes to be compressed generally should be chosen so as to reduce overall I/O rates and thus have a minimal impact on performance, unless spare CPU cycles are available. Backup compression is effective in general, even with an already compressed database, and reduces both storage and elapsed times for backup and restore. The CPU cost for backup compression is significant and can impact concurrent operations unless some means is used to limit backup CPU usage. Both new compression features should be considered, given appropriate circumstances where compression could be helpful.
Download Microsoft SQL Server 2008 data and backup compression Here
