troubleshooting Question

database in suspect mode

Avatar of Torus
Torus asked on
Microsoft SQL Server
9 Comments2 Solutions819 ViewsLast Modified:
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?
Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros