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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 780, Visits: 3,080
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 @ 2:15 PM
Points: 45,311, Visits: 43,541
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