DBCC CheckDB删除行后还原文件 [英] Restore files after a DBCC CheckDB deleted rows
问题描述
SO我运行了一个dbcc check db,它在'DocStreams'中发现了很多错误.最低维修级别为repair_allow_data_loss.
SO I ran a dbcc check db and it found a lot of errors in the 'DocStreams' where the minimum repair level is repair_allow_data_loss.
现在我已经运行了该命令.修复后的打印显示了很多这样的内容:删除了ID为(id),对象ID为(id),索引ID为1的行外数据列
Now I have ran that command. A print out of repair shows quite a few of these: Deleted off-row data column with ID (id), for object id (id), index id 1
有没有办法恢复已删除的内容?从备份中还原的数据库副本中删除?
Is there a way to restore the stuff that was deleted from a copy of the database restored from backup?
我们使用DPM,因此我能够从昨天恢复数据库的副本.如果可能的话,我只需要一些有关如何将已删除的行复制回当前数据库的说明.
We use DPM and I was able to restore a copy of the databse from yesterday. I just need some instruction if possible on how to copy the deleted rows back into the current database.
pfcjt@hotmail.com
pfcjt@hotmail.com
推荐答案
您唯一的选择是在发生损坏时从先前的位置还原.不支持REPAIR_ALLOW_DATA_LOSS.
Your only choice is to restore from prior when the corruption occurred. REPAIR_ALLOW_DATA_LOSS is not supported.
https://support.microsoft.com/zh-cn/help/841057/support-for-changes-to-the-databases-that-are-used-by-office-server-pr
https://support.microsoft.com/en-us/help/841057/support-for-changes-to-the-databases-that-are-used-by-office-server-pr
这篇关于DBCC CheckDB删除行后还原文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!