Post reply

Database in suspect Mode

  • November 10, 2008 at 12:27 pm

    #193663

    Hi All

    One of the database on my production server(Sql Server 2000) is in Suspect mode. I tried to run the following query on the db :

    sp_resetstatus , but it is throwing error message "Prior to updating sysdatabases entry for database 'ge35test', mode = 0 and status = 1073741840 (status suspect_bit = 0).

    No row in sysdatabases was updated because mode and status are already correctly reset. No error and no changes made."

    The database is having 6 mdf files and 1 ldf file.

    Please let me know how can i go ahead with this.

    Thanks

  • November 10, 2008 at 12:36 pm

    #896512

    Check in the error logs. What does it say for this database name. Is the disk that holds the data files for this online? How about the log files?

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • November 10, 2008 at 12:49 pm

    #896522

    Do this before you try to run the reset status statement..

    USE master

    GO

    sp_configure 'allow updates', 1

    GO

    RECONFIGURE WITH OVERRIDE

    GO

    and once you reset the status, run this statement below

    sp_configure 'allow updates', 0

    GO

    RECONFIGURE WITH OVERRIDE

    GO

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

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

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