Post reply

EMERGENCY MODE

  • June 19, 2013 at 5:05 am

    #275326

    HI ALL,

    I am experimenting with one of my test databases . I intentionally set the database to emergency mode.But now it is not coming out from that mode. I tried dbcc but it doesn't print any errors. Any one has any alternatives solution for this.

  • June 19, 2013 at 5:20 am

    #1625392

    ALTER DATABASE [dbname] SET ONLINE

    'Only he who wanders finds new paths'

  • June 19, 2013 at 5:26 am

    #1625395

    CheckDB with repair allow data loss or restore from backup.

    p.s. Emergency mode is the last resort for when you have a suspect database and no good backup. It's never the first thing that you should use or try

    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

  • June 19, 2013 at 5:32 am

    #1625402

    [/url]

    Nonetheless.....I think there are better ways to recover than using EMERGENCY MODE. And restoring from a good backup is one of them, if of course you have one!

    Good luck!

  • June 19, 2013 at 5:52 am

    #1625418

    actually i am trying to find whether we can take tail log backup for a database in emergency mode. and finally i stuck up in this emergency mode.

    i tried alter database commands no use.

  • June 19, 2013 at 6:18 am

    #1625431

    Alter database xxx set online worked fine now and it came out of emergency mode. But the same command doesn't work for previous attempts ... i am surprised. Can i find reasons from any logs or any where.

Viewing 6 posts - 1 through 5 (of 5 total)

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