Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Friday, September 11, 2015 1:42 AM
Points: 41, Visits: 168
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
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 4:01 AM
Points: 697, Visits: 2,730
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: Today @ 5:18 AM
Points: 44,477, Visits: 42,083
What happened, why is the database in Emergency mode?

And do you have your backups handy?



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

Post #1513847
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse