Post reply

SQL database in emrgency mode and not able to see any data

  • April 2, 2007 at 1:23 am

    #194994

    In my sql database i found that one the data in suspect mode, i had run some queries and it in emergency mode and i m not able to do bcp of my data..

    any one can give me some solution on this

  • April 13, 2007 at 6:20 am

    #700318

    Hi,

    If your database is in the Emergency mode then try to recover the database using the following undocumented dbcc command

    DBCC dbrecover (dbname [, IgnoreErrors])

    Once the database is recovered run the dbcc checkdb on it if every thing is fine the database is up or else try to BCP out the data.

    Hope this helps you !!!!!!

    Note : --> Best thing is that restore the databasde backup

     

    Minaz Amin

     

    "More Green More Oxygen !! Plant a tree today"

  • April 24, 2007 at 4:57 am

    #702106

    Try this also,

    do the DBCC CHECKDB, note the correupted table, then move other tables to a new database using DTS tool. Then try to DTS the corrupted table alone, there you can get data till the corrupted row.

     

    Thanks
    Jay
    http://www.sqldbops.com

  • July 10, 2007 at 4:26 am

    #718242

    You can also use the procedure sp_resetstatus to recover from emergency/suspect mode.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 20, 2007 at 7:33 am

    #721113

    about a month ago i had a strange problem. server rebooted after a BSOD and db went into suspect mode. errors about sql server can't obtain a lock.

    kicked everyone out including management studio connections, etc, rebooted and mounted the db. seemed even if people were connected to master db it caused problems

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

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