SQL Server数据上云恢复报错

报错信息

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 '表名xxx' 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企业版或2016以上的标准版才支持数据压缩功能

解决方法

1、换用支持压缩功能的版本

2、或者取消压缩，取消压缩的方法

https://docs.microsoft.com/zh-cn/sql/relational-databases/data-compression/disable-compression-on-a-table-or-index?view=sql-server-2017

注：查询哪些对象压缩了

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'