Results 1 to 3 of 3

Thread: suspect

  1. #1
    Join Date
    Jan 2003
    Posts
    67

    Unanswered: suspect

    What does "suspect" database mean? Is it currupted? Can it be reapired?
    Clearly I am not a DBA so please be kind.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: suspect

    Suspect means suspect.

    E.g.
    1) Device is unavailable at startup
    2) ASE flags the db that are using this device as suspect
    3) Restarting the server (including the device) => database is suspect again
    => need to change the status manually

    Code:
    sp_configure "updates", 1
    go
    update sysdatabases set status=status-256 where status&256=256
    go
    shutdown
    go

  3. #3
    Join Date
    Jan 2003
    Posts
    67
    Thanks for your help, I'm going to give it try.

Posting Permissions

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