InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:53:56 GMT20http://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspx[quote][b]kapfundestanley (2/14/2013)[/b][hr]Yes I did put it from suspect mode.In order to run dbcc checkdb.[/quote]General rule, if you want help with a corrupt DB, tell the entire story, not a portion of it.Fri, 15 Feb 2013 00:58:06 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxI was fortunate managed to get a recent backup it seems my database could be put bak online but i had managed to recover all the tables.Thu, 14 Feb 2013 21:48:03 GMTkapfundestanleyhttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxYes I did put it from suspect mode.In order to run dbcc checkdb.Thu, 14 Feb 2013 21:45:31 GMTkapfundestanleyhttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspx[quote][b]GilaMonster (2/13/2013)[/b][hr]SQL will not go into emergency mode by itself. Someone has to have set it to emergency.[/quote]That's kind of what I was getting at...either someone else went in there or we're not getting the whole story.PS now that you are on this thread I'll step aside...Wed, 13 Feb 2013 07:06:14 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxSQL will not go into emergency mode by itself. Someone has to have set it to emergency.What exactly happened, why was the DB set into emergency mode and what is in the error log?Wed, 13 Feb 2013 07:01:22 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxJust confirming, you did not put the DB into emergency mode yourself, correct? It just came up that way after the restart?Is there anything in the SQL Error Log related to the database?Wed, 13 Feb 2013 06:28:41 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxNormal restarting of the server.Wed, 13 Feb 2013 06:14:28 GMTkapfundestanleyhttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxDid the server crash? What were the circumstances around the service restarting?Wed, 13 Feb 2013 06:09:23 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxDatabase is in emergency state.Wed, 13 Feb 2013 06:07:47 GMTkapfundestanleyhttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxDid you by chance reboot the service/server in an attempt to kill a long-running transaction or try to remediate a transaction that had been killed and was in the process of rolling back?What is the state of the database?[code="sql"]SELECT name, state_descFROM sys.databasesWHERE name = N'yourDBname';[/code]Wed, 13 Feb 2013 05:40:25 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxDatabase taking long to bring online in 1hr 15 minutes.Is this normal.I am SQL Server.Wed, 13 Feb 2013 05:05:00 GMTkapfundestanley