Database suspect status~

  • Out Corporate SQL Database appear Supspect!

    i have already do it follow steps:

    run sp_resetstatus 'NVS'

    stop MS SQLServer

    restart MS SQLServer

    but it appear again!

    how do i do it ?

    error information:

    Server: Msg 906, Level 22, State 2, Line 1

    Could not locate row in sysobjects for system catalog 'Sysobjects' in database 'NVS'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.


    I love Database administrate job!

  • It appears your database is truly corrupted and attempts to reset the status will not be successful (as you've found out).

    Do you have a recent full backup to restore from?

    Were there any actions undertaken (eg. detach/attach) leading up to the suspect status occurring?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • Hi,

    If you haven't a recent backup then you can do the following.

    Look in you logs first, to see if is autorecovering. If nothing is in the logs, run sp_who2 to see if there is a rollback on the db in question. If there is leave it it will 'hopefully' recover.

    If not, and as reset status will not work you'll have to set the db to emergency mode

    update sysdatabases

    set status = 32768

    Then set the db to single user

    exec sp_dboption 'yourdb', 'single user', 'true'

    Then run dbcc checkdb ('yourdb', REPAIR_REBUILD)

    Set single user to false.

    Hopefully this will work, it has for me a few times.

    Good luck!!

    Ritch

    "I didn't do anything it just got complicated" - M Edwards


    "I didn't do anything it just got complicated" - M Edwards

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

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