Database in Recovery Pending state

  • bobba

    SSCommitted

    Points: 1605

    Good Morning,

    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.

  • DinoRS

    SSCrazy

    Points: 2513

    wild guess here: AV it was. Proof? Check if the files are in the whitelist for the AV.

  • crow1969

    SSCrazy

    Points: 2864

    You may also want to check to make sure that AUTO_CLOSE is not turned on for this database.

    If this is not an anti-virus problem, then it might be a server backup issue.  Check with the server admins how they run the backups.  Snapshots of the disk will not interrupt anything, but old-fashioned copy everything from disk could interfere with any file viewed as closed.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply