Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Question Unanswered: Suspect Database

    Hi all,

    We recently had some kind of error on one of the server's hard drives. The network guys, reinintialized (or something) and were able to bring everything back. However, two of my databases now is "Suspect" and can't be used. Both the MDF & LDF exist, and there are no indications of actual data loss. What can I do with a "suspect" database ? SQL 2K

    What should I do to recover these two databases?
    Thank you for all your suggestions.

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    First check SQL Error log for a reason why the server marked the databases suspect. Then try sp_detach_db/sp_attach_db.
    If this does not work, - sp_attach_single_file_db
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jul 2004
    I had the same issue, I was able to attach the database, with no problem.



Posting Permissions

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