InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 09:56:32 GMT20http://www.sqlservercentral.com/Forums/Topic946612-146-1.aspxThank u, now recovered but still am getting one transactions likeOldest active transaction: SPID (server process ID): 123 UID (user ID) : -1 Name : implicit_transaction LSN : (413051:16337:1) Start time : Jul 2 2010 1:55:32:310PM SID : 0x17077e53df9a7346bb0ec67e76740828DBCC execution completed. If DBCC printed error messages, contact your system administrator.Fri, 02 Jul 2010 02:25:28 GMTSaravanan_tvrhttp://www.sqlservercentral.com/Forums/Topic946612-146-1.aspxEnterprise edition has a feature called fast recovery. It means that, after an unexpected shutdown, the database will come online after phase 2 of the restart recovery has completed, instead after phase 3 (which the other editions do). Once the DB comes online, the rollback continues until it's complete. These are deferred transactions.Be patient, this is a feature, not a problem, once the rollback has finished you'll be able to run checkDB.Fri, 02 Jul 2010 01:53:03 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic946612-146-1.aspxHi ,Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) [b]DBCC OPENTRAN[/b]Transaction information for database 'DB'.Oldest active transaction: SPID (server process ID): 51 UID (user ID) : -1 Name : implicit_transaction LSN : (412576:18904:9) Start time : Jul 2 2010 4:17:57:390AM SID : 0x17077e53df9a7346bb0ec67e76740828DBCC execution completed. If DBCC printed error messages, contact your system administrator.[b]DBCC check db[/b]Msg 7929, Level 16, State 1, Line 1Check statement aborted. Database contains deferred transactions.Fri, 02 Jul 2010 01:25:13 GMTSaravanan_tvrhttp://www.sqlservercentral.com/Forums/Topic946612-146-1.aspxWhat's the state of the database? (query sys.databases)What's the exact version (patch, CU and hotfix) and edition of SQL? (select @@version)Fri, 02 Jul 2010 01:19:03 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic946612-146-1.aspxDear all,While i running the dbcc reindex, unfortunately system restart with hardware failure, after that we are unable to access the DB, if i check with[b] DBCC check[/b] db gives the below errorMsg 7929, Level 16, State 1, Line 1 Check statement aborted. Database contains deferred transactions.unable to open the table all so... and any front end software also..please tell me to come out from this problem..Fri, 02 Jul 2010 01:04:25 GMTSaravanan_tvr