Post reply

Database on emergency mode

  • November 13, 2013 at 6:26 am

    #279993

    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

  • November 13, 2013 at 6:33 am

    #1666038

    Did you specify 'with rollback immediate' or anything like that (to roll back uncommitted transactions)? Because if not it can take ages.

  • November 13, 2013 at 6:39 am

    #1666040

    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

Viewing 3 posts - 1 through 2 (of 2 total)

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