Error 2601, Severity 14, State 1, Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'

Question

实例:SQLServer 2008 SP1 标准版

一个数据库启用了change tracking.进行备份时报错:

Error 2601, Severity 14, State 1, Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'

按照MS的解释http://support.microsoft.com/kb/2522893,

对数据库实例安装了SP3补丁.

但是之后仍然不能进行备份,相同的错误.

请问需要怎么解决呢?

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 1

Check this: http://blogs.msdn.com/b/davidhardin/archive/2011/09/28/sql-server-2008-r2-change-tracking-and-backup-fix.aspx.

Answer 2

Hi,

按照你给的那个链接，是要你安装Cumulative update package 2 for SQL Server 2008 Service Pack 3，并不是要你只去安装SQL Server 2008 Service Pack 3，请你检查一下：

下载Cumulative update package 2 for SQL Server 2008 Service Pack 3:http://support.microsoft.com/kb/2633143.

Best Regards，

---

Amy Peng
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.