Failed to flush the commit table to disk in dbid # due to error 2601 Microsoft SQL Server 2008 R2 (SP1) - 10.50.2796.0 (X64)
-
Thursday, May 03, 2012 4:55 PM
I had this problem again, but this time on a box running sql server 2008 R2 SP1 with CU 4.
Backup Encountered exception: 0x80131904 Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'
Failed to flush the commit table to disk in dbid # due to error 2601
This problem is supposed to be fixed, has anyone else had this problem after CU4 on 2008 R2 SP1?
More details about this are in these Knowledge Base Articles.
http://support.microsoft.com/kb/2633146
http://support.microsoft.com/kb/2603910
Maybe it needs to be fixed again Again?
- Edited by Tom Evers Thursday, May 03, 2012 5:51 PM
All Replies
-
Monday, May 07, 2012 7:53 AMModerator
Hi Tom,
From the articles you list, I think this problem is fixed in SQL Server 2008 R2 SP1.
Since it is not work, you could try to repair the SQL Server Instance.
Reference: http://msdn.microsoft.com/en-us/library/cc646006(v=sql.105).aspx.
Thanks,
Maggie
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, June 07, 2012 7:41 AM
.png)
