无法恢复启用CDC的数据库 [英] unable to restore DB that is CDC enabled

问题描述

1） 数据库恢复已完成但有错误

1)  DB restore is completed with errors

消息207，等级16，状态1，程序sp_cdc_vupgrade，第104行

Msg 207, Level 16, State 1, Procedure sp_cdc_vupgrade, Line 104

2）尝试运行sp_cdc_enable_table，其中NON-NULL  @captured_column_list以错误结束

消息2812，级别16，状态62，过程sp_cdc_enable_table_internal，行297

2) attempt to run sp_cdc_enable_table having NON-NULL @captured_column_list ends with error
Msg 2812, Level 16, State 62, Procedure sp_cdc_enable_table_internal, Line 297

推荐答案

Hello Olexandr，

Hello Olexandr,

哪个版本& edition是源SQL Server，您从中获取备份以及哪个版本和版本。 edition是目标SQL Server，您尝试还原备份？

Which version & edition is the source SQL Server, where you took the backup from and which version & edition is the target SQL Server, where you are trying to restore the backup?

这篇关于无法恢复启用CDC的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！