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.
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 7Failed 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 7Failed 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. Read More
