My new blog present here.

Featured Post

Insights into Sitecore Search: A Definitive Introduction

A key component of digital experience management is effective information retrieval. A simplified approach is required for websites, applications, and platforms containing a lot of material so that consumers can easily get the data they require. This need is met by Sitecore, a well-known name in the field of digital experience platforms (DXPs), which provides powerful and comprehensive search functionality. We will travel into the realm of Sitecore Search in this article, learning about its capabilities, architecture , and the enormous value it offers both developers and end users. Introduction to Sitecore Search    A headless content discovery platform powered by AI , Sitecore Search enables you to build predictive and custom search experiences across various content sources. To extract and index you

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.

Comments

Popular posts from this blog

Sitecore GraphQL Queries

Twenty 20 Masti:

Sitecore Experience Edge GraphQL Queries