Compress row data
Compressing row data can make backing up and restoring data more efficient.
Compressing row data before backing it up can improve the speed
of backing up and restoring and requires less backup media. A smaller
size of data results in the following advantages over uncompressed
data during backup and restore:
- Backing up is quicker.
- Restoring is quicker.
- The logical logs are smaller.
- The backup image is smaller.
Using an external compression utility to compress a backup image of compressed row data might not reduce the size of the backup image, because already compressed data usually cannot be further compressed. In some cases, the size of the backup image of compressed row data might be larger than the size of the backup image that was compressed by an external utility.