Suspect Table, Inaccessible Files?
Posted on 2006-06-13
I have a database that works fine on SQL 2000 Server on my web server. However, when I copy the .MDF and .LDF files to my test server on my personal laptop, the database is labeled 'Suspect', and when I try to access it it gives the following error:
"Database 'msm' cannot be opened due to inaccessibly files or insufficient memory or disk space. See the SQL Server errorlog for details."
I don't understand what's going on...
The following is from the errorlog:
2006-06-13 16:17:55.98 spid51 Starting up database 'msm'.
2006-06-13 16:17:55.98 spid51 udopen: Operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device C:\Inetpub\wwwroot\MSSQL$ORBUSDEV\msm_Data.mdf.
2006-06-13 16:17:55.98 spid51 FCB::Open failed: Could not open device C:\Inetpub\wwwroot\MSSQL$ORBUSDEV\msm_Data.mdf for virtual device number (VDN) 1.
The file is there. I can see it and I can browse to it. I tried re-downloading it to my laptop with no change or improvement.