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

Database on emergency mode Expand / Collapse
Author
Message
Posted Wednesday, November 13, 2013 6:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 23, 2014 9:40 AM
Points: 41, Visits: 161
Hi Team ,

I have set my database in emergency mode then i ran the command as like alter database xyz set single_user but it is taking longer time put in single user mode .

Can I know what would be reason and i run the dbcc checkdb command it did not show any erro.

Please suggest me











































Post #1513839
Posted Wednesday, November 13, 2013 6:33 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 499, Visits: 1,830
Did you specify 'with rollback immediate' or anything like that (to roll back uncommitted transactions)? Because if not it can take ages.
Post #1513845
Posted Wednesday, November 13, 2013 6:39 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: Yesterday @ 3:43 PM
Points: 43,047, Visits: 36,206
What happened, why is the database in Emergency mode?

And do you have your backups handy?



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 #1513847
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse