Forum Discussion
Failed to flush the commit table to disk - SQL Server 2012
I created a replication and encountered issues so I deleted it.
Currently I cannot take backups on my database.
I run DBCC CHECKDB ('MWIntegra') WITH NO_INFOMSGS, ALL_ERRORMSGS; and got the error below:
Msg 2601, Level 14, State 1, Procedure sp_flush_commit_table, Line 16 [Batch Start Line 5]
Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (2491092263).
The statement has been terminated.
Msg 2601, Level 14, State 1, Procedure sp_flush_commit_table, Line 16 [Batch Start Line 5]
Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (2491092263).
Msg 3999, Level 17, State 1, Line 7
Failed to flush the commit table to disk in dbid 7 due to error 2601. Check the errorlog for more information.
Msg 3999, Level 17, State 1, Line 7
Failed to flush the commit table to disk in dbid 7 due to error 2601. Check the errorlog for more information.
I have read around but cannot seem to get it resolved.
I currently do not have a back up I can restore from.