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:

SELECT name, state_desc from sys.databases
GO
view raw SQL DB Status.sql hosted with ❤ by GitHub

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 Edge GraphQL Queries

Image
The Headless development in Sitecore is powered by a layer of services, API endpoints, and rendering SDKs: Services and API endpoints Sitecore Headless Services Sitecore Experience Edge for XM Rendering SDKs Sitecore ASP.NET Rendering SDK Sitecore JavaScript Rendering SDKs (JSS) In this article, we will explore about Sitecore scalable API layer called Sitecore Experience Edge which provides you a Sitecore-hosted GraphQL (GQL) API. With these Edge GraphQL (GQL) endpoint you can build your solution in any language and pull the required content with the help of GraphQL (GQL) . The major GraphQL APIs of Sitecore Experience Edge are: Preview API Delivery API You can check more details about these APIs at Type of Sitecore Experience Edge API . GraphQL is a query language for these APIs t...
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