VLDB is stuck in recovery state. It's a permission issue, now what should I do?

SQL Server database which is very large (4TB) is stuck in recovery state. Reason: Data center had a planned downtime and we had to turn the physical machine off and when it turned on, as I read in error logs, SQL Server couldn't access the files, because files were on a SAN machine, and probably things didn't went smooth.


FCB::Open failed: Could not open file E:\SomeFolder\SomeDatabase.mdf for file
number 1. OS error: 5(Access is denied.).

Now that I've made sure that SAN is up and running, and permission are OK, how can I tell SQL Server to continue recovering? Since this database is very large, I don't want to interrupt the course of recovering and start from the beginning. And also, any backup would take hours to complete.

SQL server service account does not have permission to access the file.

• Navigate to the folder in which this file is residing

• Grant Full control privilege on this folder to the SQL server service account.

• Bring the DB Offline - Online or Restart SQL server services.

StackExchange Database Administrators Q#126419, answer score: 2