Emergency state

Question

Emergency state

kapfundestanley

SSCertifiable

Points: 5637
More actions
February 13, 2013 at 5:05 am

#270805

Database taking long to bring online in 1hr 15 minutes.Is this normal.I am SQL Server.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 1

Did 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?

SELECT name,

state_desc

FROM sys.databases

WHERE name = N'yourDBname';

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 2

Database is in emergency state.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 3

Did the server crash? What were the circumstances around the service restarting?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 4

Normal restarting of the server.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 5

Just 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?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

SQL 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?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 7

GilaMonster (2/13/2013)
SQL will not go into emergency mode by itself. Someone has to have set it to emergency.

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...

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 8

Yes I did put it from suspect mode.In order to run dbcc checkdb.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 9

I 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.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

kapfundestanley (2/14/2013)
Yes I did put it from suspect mode.In order to run dbcc checkdb.

General rule, if you want help with a corrupt DB, tell the entire story, not a portion of it.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass