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,