问题描述:
SQL Server数据库出现“Data compression and vardecimal storage format are only supported on SQL Server Enterprise Edition”报错
SQL Server数据库出现以下报错,其中[$Name]为表名称。
Recovery is writing a checkpoint in database 'xxx' (9). This is an informational message only. No user action is required. Database 'xxx' cannot be started in this edition of SQL Server because part or all of object '[$Name]' is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterprise Edition. Database 'xxx' cannot be started because some of the database functionality is not available in the current edition of SQL Server
版本兼容性问题,SQL Server企业版或者SQL Server 2016以上的标准版才支持数据压缩功能。
以下是两种解决方法:
查询压缩对象的更多信息
以下是查询压缩对象SQL语句。
select name,
type_desc,
data_compression_desc
from sys.partitions p
join sys.objects o on p.object_id = o.object_id
where p.data_compression_desc<>'NONE'
and o.type='U';
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。