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 ...
Post a Comment

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

Post a Comment

Popular posts from this blog

Sitecore GraphQL Queries

Image
This article will provide the details about Sitecore GraphQL queries usage and how it will be useful in creating Sitecore projects especially Sitecore JSS projects. The topics covered under this Sitecore GraphQL article are: •    Overview of Sitecore GraphQL (GQL) •    Setup GraphQL (GQL) in Sitecore •    Usage of Sitecore GraphQL (GQL) in Sitecore JSS •    GraphQL (GQL) Queries Usage         o   Get an item by path and show field id and name       o   Return the name and value from all fields       o   Get the values of Treelist or Multilist field type       o   Get the template field details with values of current item       o   Get the field values using Aliases       o   Return a specific field with Alias ...
Read more

Sitecore Experience Manager Cloud (XM Cloud) Building blocks

Image
Sitecore Experience Manager Cloud, or XM Cloud is a game-changing force in the field of digital experience management in the age of cloud computing. We must identify the fundamental components that make up this cutting-edge platform in order to fully appreciate its capabilities. Join us as we dissect the fundamental elements that make up the Sitecore Experience Manager Cloud (or XM Cloud) architecture and investigate how they work together to produce a dynamic, scalable, and customized digital experience environment. Sitecore XM Cloud Overview    The SaaS enterprise-ready , cloud-native CMS from Sitecore called the Experience Manager Cloud (XM Cloud) allows for the creation of content only once and delivers it to every channel for exceptional client experiences. Developers and marketers can q...
Read more

Configuring Sitecore Next.js Headless SXA Multisite App in a Sitecore Container

Image
Leading digital experience platform Sitecore offers strong capabilities for developing reliable websites and applications. The headless CMS and Jamstack architecture trends have been very popular in recent years. Sitecore provides Headless SXA (Sitecore Experience Accelerator) as a solution to decouple the front-end presentation layer from the content management capabilities since it recognizes the value of headless capabilities. In this article, we will guide you through the process of configuring a Sitecore Next.js multisite app and integrating it with Headless SXA in a Sitecore container. This setup allows you to leverage the benefits of Next.js, a popular React framework for server-side rendering, and the flexibility of Headless SXA for managing and delivering content. Table of Contents Step 1: Set Up the Sitecore Container Step 2: Add support for Sitecore SXA in Sitecore Headless Container setup St...
Read more