Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    2

    Unanswered: SQL2000 - Suspect database

    Hi folks,

    The events behind this question are as follows:
    An SQL2000 server was rebooted midway through a reboot. At the point the second reboot was initiated (from the SQL log), the server was midway through 'starting up' each of the databases. After the second reboot was complete, all the databases that had not started up prior to the second reboot were shown as 'suspect'.

    So far we have tried the following:
    1) Physically copying the 'suspect' dabase .mdf files gives us an 'access denied' error message (tried Explorer and DOS shell). We can copy and paste databases that are not 'suspect' fine.
    2) Running sp_status_reset on one of the 'suspect' databases The response we got is this:
    'Prior to updating sysdatabases entry for database 'finprod', mode = 0 and status = 1073741832 (status suspect_bit = 0).
    No row in sysdatabases was updated because mode and status are already correctly reset. No error and no changes made.'
    3) Detaching another of the 'suspect' databases and reattaching it gives us a 'Create file encountered operating system error 5 (error not found) while attempting to iopen or create a physical file.

    Any ideas on how to rectify this without restoring the files from backup?
    Many thanks in advance,

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    If nothing fetched using SP_RESETSTATUS then only option is to restore from good known backup.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Posts
    12
    Before doing anything, you should check your SQL Server errorlogs for the causes of database suspect. You may post the errors here so we can follow up.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, assess the information from event viewer logs also for any H/w issues.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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