SQL Server Performance

database in suspect mode

Discussion in 'SQL Server 2005 Log Shipping' started by jasmin123, Jul 2, 2007.

  1. jasmin123 New Member

    what are the steps to get database out of suspect mode before you
    apply any backup.
    jasmin123, Jul 2, 2007
    #2

  2. dineshasanka Moderator

    http://www.devx.com/vb2themax/Tip/18624

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Jul 3, 2007
    #2

  3. satya Moderator

    There is more information available on SQL Server books online about how can you recover from a suspect database, KBAhttp://support.microsoft.com/kb/889266 too.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
    satya, Jul 3, 2007
    #2

  4. ghemant Moderator

    ghemant, Jul 3, 2007
    #2

  5. kvs1983 New Member

    If you have the db backup, then its better to detach the db and restore the db using the available backup. It will work fine.

    Sagar
    kvs1983, Jul 4, 2007
    #2

  6. satya Moderator

    ... before that it is better to see why this database is getting suspect state, such as hardware issues or any corrupted page!

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
    satya, Jul 5, 2007
    #2

  7. dbajohnny New Member

    Hi,
    Try this it will work.EXEC sp_resetstatus 'Yourdatabasename'ALTER DATABASE Yourdatabasename SET EMERGENCYDBCC checkdb(' Yourdatabasename ')ALTER DATABASE Yourdatabasename SET SINGLE_USER WITH ROLLBACK IMMEDIATEDBCC CheckDB (' Yourdatabasename ', REPAIR_ALLOW_DATA_LOSS)
    ALTER DATABASE Yourdatabasename SET MULTI_USER
    bye
    John
    dbajohnny, Apr 22, 2008
    #3

Share This Page