Sitecore Error Troubleshooting: Database 'xxx' cannot be opened due to inaccessible files or insufficient memory/ Database in Recovery Pending State

Sitecore Error Troubleshooting: Database 'xxx' cannot be opened due to inaccessible files or insufficient memory/ Database in Recovery Pending State:

In my local system, I was having space issue, so i tried to move all SQL DB files (*.mdf and *.ldf) from C drive to D drive. For this I followed the site Sqlshack.com .

After all the steps, I stared getting the error Database 'XXX' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details and Database in Recovery Pending State.



After spending some time, I found that this issue is related to the Folder level access for SQL Server, due to this Sitecore instance not able to access the Database files and SQL Server 2016 databases showing as Recovery Pending State:


To verify the current state of Database, i executed SQL query:


And found that some DB's was ONLINE and rest are in RECOVERY_PENDING state:

To resolve the Database 'XXX' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details and Database in Recovery Pending State, we have to perform following steps:

  • The service MSSQL$SQL2016 for SQL Server (SQL2016) running under the user NT Service\MSSQL$SQL2016, so we need to provide FULL access to this user on the new location folder or DB files of Database files.
  • Apart from above user, we also need to provide FULL access to OWNER RIGHTS user.

After providing FULL access to above mentioned user, all DB will come online and you will be able to access the Sitecore instance.

Post a Comment

Previous Post Next Post