We had an issue yesterday where SQL Alerts were generated from one of our servers. Checked the server, one of the databases was found to be in a "Recovery Pending" state.
Viewing the error log, found the following:
2019-09-17 00:08:33.38 spid55 Error: 17204, Severity: 16, State: 1.
2019-09-17 00:08:33.38 spid55 FCB::Open failed: Could not open file E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\xxx.MDF for file number 1.
OS error: 32(The process cannot access the file because it is being used by another process.).
Asked one of our server administrators to check since OS appeared to be the issue, he found nothing. As you can see, this was not a "system cannot find the file specified" or "access denied". Brought the database back online, ran an integrity check - no issues.
Any ideas as to what cause this problem? Checked event viewer - nothing. My money was anti-virus software but really don't know.
Comments / URLs are appreciated.