Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Emergency state Expand / Collapse
Author
Message
Posted Wednesday, February 13, 2013 5:05 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 10, 2014 5:24 AM
Points: 966, Visits: 1,166
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
Post #1419413
Posted Wednesday, February 13, 2013 5:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 7,127, Visits: 12,728
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
Post #1419433
Posted Wednesday, February 13, 2013 6:07 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 10, 2014 5:24 AM
Points: 966, Visits: 1,166
Database is in emergency state.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Post #1419451
Posted Wednesday, February 13, 2013 6:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 7,127, Visits: 12,728
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
Post #1419454
Posted Wednesday, February 13, 2013 6:14 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 10, 2014 5:24 AM
Points: 966, Visits: 1,166
Normal restarting of the server.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Post #1419459
Posted Wednesday, February 13, 2013 6:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 7,127, Visits: 12,728
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
Post #1419470
Posted Wednesday, February 13, 2013 7:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:50 AM
Points: 40,209, Visits: 36,618
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 2008, MVP
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

Post #1419492
Posted Wednesday, February 13, 2013 7:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 7,127, Visits: 12,728
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
Post #1419495
Posted Thursday, February 14, 2013 9:45 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 10, 2014 5:24 AM
Points: 966, Visits: 1,166
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
Post #1420369
Posted Thursday, February 14, 2013 9:48 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 10, 2014 5:24 AM
Points: 966, Visits: 1,166
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
Post #1420370
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse