.ldf文件保存失败的插入行 [英] Do .ldf file save failed insert rows

问题描述

有没有办法恢复由于''无法插入重复的标识列''错误而未插入指定表的行。

我可以从日志文件中恢复这些行.ldf 。



使用的工具：Sql Server 2008，带恢复模型的数据库：完整

Is there any way to recover rows which had not been inserted into a specified table due to ''Cannot insert duplicate identity column'' error.
Can I recover these rows from log file .ldf.

Tools used: Sql Server 2008, DB with Recovery Model: Full

推荐答案

是否有任何方法可以恢复由于无法插入重复的标识列错误而未插入指定表的行。

编号数据未保存且错误为提高。由于错误情况，无法恢复任何未保留的数据。

Is there any way to recover rows which had not been inserted into a specified table due to ''Cannot insert duplicate identity column'' error.
No. Data was not saved and error was raised. There would be no way to recover any data that was not persisted because of the error condition.

这篇关于.ldf文件保存失败的插入行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！