The tables that will not restore are compressed with the option DATA_COMPRESSION = PAGE. This is a SQL Server 2008 feature.
Page compression applies the following compression techniques to each data page:
When you enable page compression, row compression is automatically enabled. Dictionary compression is applied after prefix compression. Dictionary compression is not limited to a single column; it is applied to the entire page.
Unsupported
We do not support in-database compression with OLR, so it’s not supported. This is noted in the “Review Known Issues” F1 on-line section of Help.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center