Post reply

Database in suspect mode

  • July 12, 2010 at 12:48 am

    #157073

    Hi,

    I have one database DB_Test. The database is in suspect mode. I m not able to use it.

    Also I don't have any valid backup for it. I have also executed command as follows:

    EXEC sp_resetstatus 'DB_Test';

    ALTER DATABASE DB_Test SET EMERGENCY

    DBCC checkdb('DB_Test')

    ALTER DATABASE DB_Test SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    DBCC CheckDB ('DB_Test', REPAIR_ALLOW_DATA_LOSS)

    ALTER DATABASE DB_Test SET MULTI_USER.

    So I how can get my original database. Even if I recover only structure of database then also it will do. It is not necessary that I should get data along with the structure.

    So plz give me solution for the same.

    Regards,

    Nikhil Desai

  • July 12, 2010 at 2:16 am

    #1191347

    Too many steps done in one go.

    Firstly, query sys.databases, check what the value for state_desc is for this database. What is it.

    Check the SQL error log. There WILL be entries in there stating why the DB has been marked suspect. Find them and post them here.

    After you set the DB to emergency mode, were there any errors (did the set to emergency fail or succeed?) Could you query the database?

    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 2 posts - 1 through 1 (of 1 total)

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