检查详情
备份集中的库表数据必须有主键，或者非空唯一键，否则任务报错。
修复方法
请按报错提示，对源库中相应的表数据进行修改，增加主键或者非空唯一键，再使用新的备份集进行恢复。
﻿

","showToc":false,"toc":"

修复方法

","recentReleaseTime":"2022-11-25 17:27:35","videoConfig":{"position":"top"},"githubUrl":"https://github.com/tencentyun/qcloud-documents/blob/master/product/数据库/数据库备份DBS/08%20校验不通过处理方法/恢复数据库检查/06%20主键检查.md","isSlate":true,"writeNodeId":"88739481043103744","displayEditEntry":true,"slate":"\"[{\\\"children\\\":[{\\\"text\\\":\\\"检查详情\\\"}],\\\"nodeId\\\":\\\".E6.A3.80.E6.9F.A5.E8.AF.A6.E6.83.85\\\",\\\"type\\\":\\\"h2\\\"},{\\\"children\\\":[{\\\"text\\\":\\\"备份集中的库表数据必须有主键，或者非空唯一键，否则任务报错。\\\"}],\\\"type\\\":\\\"p\\\"},{\\\"children\\\":[{\\\"text\\\":\\\"修复方法\\\"}],\\\"nodeId\\\":\\\".E4.BF.AE.E5.A4.8D.E6.96.B9.E6.B3.95\\\",\\\"type\\\":\\\"h2\\\"},{\\\"children\\\":[{\\\"text\\\":\\\"请按报错提示，对源库中相应的表数据进行修改，增加主键或者非空唯一键，再使用新的备份集进行恢复。\\\"}],\\\"type\\\":\\\"p\\\"},{\\\"type\\\":\\\"p\\\",\\\"children\\\":[{\\\"text\\\":\\\"\\\"}]}]\"","sdkPath":"//qcloudimg.tencent-cloud.cn/static/document/tea-slate-sdk.v0.1.11"},"relationConfig":{"switch":0},"shareConfig":[],"advanced":[]},"relatedHotArticleList":[]},"staticContext":{"isMobile":false,"isMiniProgram":false,"isWechat":false,"isPreview":false,"originalUrl":"/document/product/1513/70208","CDN_DOMAIN":"cloudcache.tencent-cloud.com","QCLOUD_DOMAIN":"cloud.tencent.com","isLegalReferer":true,"ssrInfo":{},"language":"zh","requestId":"5jRZFTvmbc"}},"0-0":null},"actionData":null,"errors":null}