Sitecore Experience Accelerator (SXA): What is Partial Design in SXA? The Sitecore Experience Accelerator (SXA) emphasize on the re-usability. For this Sitecore Experience Accelerator (SXA) providing the concept of Partial Design. The Partial Design is the sub-set of page.  Its uses set of responsive and reusable renderings. These renderings can be added to 12 columns provided by Sitecore SXA Theme. The set of SXA Partial Designs help to create complete page. For example, one website having Header and Footer: Header generally contains following items: Logo with link Navigation Search Text Box In ASP.NET MVC based project we used to create partial views to add above mentioned controls and including these partial design in the Master page, so that it can re-used throughout the website for consistent look and feel. In the same way, we can utilize Sitecore SXA Partial Design to create sub-set of page by adding multiple controls into the canvas provided by Si...

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 '...