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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center