InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 10:04:28 GMT20http://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspxdeletedTue, 29 Jan 2013 08:23:36 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspxYes Gail I have go through the link you provided.Mine is SQL Server 2008 R2 SP1 & CU3 and in that post its mentioned like fix for this issue was first released in Cumulative Update 1 for SQL Server 2008 R2 Service Pack 1.Do i need to upgrade to SP2? What I am worried now is all these requires restart.Tue, 29 Jan 2013 02:51:57 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspx[quote][b]Ratheesh.K.Nair (1/29/2013)[/b][hr]DBCC CHECKDB WITH TABLOCK GAVE BELOW ERROR---------------------------------------------------------------Msg 5030, Level 16, State 12, Line 1The database could not be exclusively locked to perform the operation.Msg 7926, Level 16, State 1, Line 1Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.[/quote]Make sure there are no users in the database and try again. Tablock requires exclusive locks.Definitely looking like it's not a checkDB problem. Did you read the blog post I referenced?Tue, 29 Jan 2013 02:34:49 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspxSNAPSHOT CREATION FAILED WITH BELOW ERROR--------------------------------------------------------Msg 2601, Level 14, State 1, Procedure sp_flush_commit_table, Line 15Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (55822684521).The statement has been terminated.Msg 2601, Level 14, State 1, Procedure sp_flush_commit_table, Line 15Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (55822684521).The statement has been terminated.Msg 3999, Level 17, State 1, Line 1Failed to flush the commit table to disk in dbid 8 due to error 2601. Check the errorlog for more information.Msg 3999, Level 17, State 1, Line 1Failed to flush the commit table to disk in dbid 8 due to error 2601. Check the errorlog for more information.DBCC CHECKDB WITH TABLOCK GAVE BELOW ERROR---------------------------------------------------------------Msg 5030, Level 16, State 12, Line 1The database could not be exclusively locked to perform the operation.Msg 7926, Level 16, State 1, Line 1Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.Tue, 29 Jan 2013 02:30:34 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspxThanks SQL Gurus Paul and Gail for the response.Tue, 29 Jan 2013 02:29:18 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspxCheck this out, see if it's applicable.[url]http://blogs.msdn.com/b/davidhardin/archive/2011/09/28/sql-server-2008-r2-change-tracking-and-backup-fix.aspx[/url]Mon, 28 Jan 2013 07:51:48 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspxCan you run the CHECKDB using WITH TABLOCK?Can you also try creating a database snapshot of your database to see if that succeeds? (nothing to do with CHECKDB)I suspect there's something amiss with it and when the snapshot creation starts, it's trying to roll back a transaction in the snapshot and failing.Mon, 28 Jan 2013 07:45:46 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspxMsg 2601, Level 14, State 1, Procedure sp_flush_commit_table, Line 15Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (55822684521).The statement has been terminated.Msg 2601, Level 14, State 1, Procedure sp_flush_commit_table, Line 15Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (55822684521).Msg 5269, Level 16, State 1, Line 1Check terminated. The transient database snapshot for database 'ABC' (database ID 8) has been marked suspect due to an IO operation failure. Refer to the SQL Server error log for details.Msg 3999, Level 17, State 1, Line 1Failed to flush the commit table to disk in dbid 8 due to error 2601. Check the errorlog for more information.Msg 3999, Level 17, State 1, Line 1Failed to flush the commit table to disk in dbid 8 due to error 2601. Check the errorlog for more information.Msg 0, Level 20, State 0, Line 0A severe error occurred on the current command. The results, if any, should be discarded.Mon, 28 Jan 2013 07:34:53 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspxPlease run the following and post the full and complete, unedited output.[code]DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS[/code]Fri, 25 Jan 2013 07:38:52 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1411697-1550-1.aspxHi experts,CHECKDB threw errorCannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (55822684521).Fri, 25 Jan 2013 06:55:06 GMTRatheesh.K.Nair