I separated the database into 3 files, mydb.mdf, mydb.ndf, mydb2.ndf. Today the database suddenly hanged and then I rebooted the OS. But after rebooting, the database was in suspect mode. Firstly, I thought the log file is corrupted so that I renmaed the files to mydb.mdf.bak, mydb.ndf.bak, mydb2.ndf.bak, removed the suspect database and then created the same database name mydb and database files. I stopped the service, deleted the database files and copy back the bak fiels to the database files. However, after I started the service, the database was still in suspect mode.
Finally, I checked the event log and found the following error
Error: 823, Severity: 24, State: 3
I/O error 33 (the system cannot access the file because another process already locked some part of the file) detected during write at offset 0x000006931760000 in the file 'c:\data\mydb3.ndf'
What's the problem? the ndf is corrupted?? how can I recover the file?