Results 1 to 3 of 3

Thread: sp_resetstatus not working?...

  1. #1
    Join Date
    Mar 2003
    Posts
    383

    sp_resetstatus not working?...

    Hi:
    I tried to restore a database and get 'suspect' gray sign on it and found in the error.log of "Bypassing recovery for database 'DBxyz' because it is marked IN LOAD."

    Then, I tried the following T/sql:
    sp_resetstatus DBxyz

    and got following response from exec:
    Prior to updating sysdatabases entry for database 'DBxyz', mode = 0 and status = 4194361 (status suspect_bit = 0).
    No row in sysdatabases was updated because mode and status are already correctly reset. No error and no changes made.

    after I drop it, and restore again, it works. I remember that sp_resetstatus worked fine in the SQL6.5, but not so in sql2000....

    thanks
    David

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    It just changes db status but doesn't fix any problem, still have to restore from backup.

  3. #3
    Join Date
    Mar 2003
    Posts
    383
    So, the suspect status if happen during the restoring, it is a mssql issue, sp_reset won't help.

    While a suspect status for an existing database, the sp_reset should be useful to take off the suspect status.

    thanks for the info rmiao
    -D

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •