SQL Server Analysis Services CompressionUnique to HyperBac
HyperBac extensible architecture enables backup and online compression operations for SQL Server Analysis Services in SQL Server 2005 and SQL Server 2008.
Compression is obtained seamlessly during SSAS backup operations, in many cases the compression obtained in greater than in built SSAS backup compression in SQL Server. As seen below an SSAS backup performed with HyperBac is half the size of a comparable backup performed using native compression in SQL Server 2008 Enterprise Edition:
| Backup Type |
|
File Size (KB) |
|
% Compression |
| Native Without Compression |
|
65,380 |
|
- |
| Native With Compression |
|
36,772 |
|
43% |
| Using HyperBac Compression |
|
20,018 |
|
70% |
For more information and configuration steps, visit SQL Server Analysis Services Compression Using HyperBac.
|
HyperBlog