Skip to main content

SharePoint Migration : This content database has a schema version which is not supported in this farm

Today one of my client was expecting to restore a SharePoint Site Collection from and Database that he already took as a backup.  I followed below steps.
          1.       Imported content database to SQL of the farm where the site is to be restored.
          2.       Created a web application.
          3.       Visited manage content database, set the current database property to offline.
          4.       Click on add a new content database.
          5.       Set the name of the content database same as the database that is imported to SQL.
  SharePoint gave me below error.
“This content database has a schema version which is not supported in this farm."
I tried to use powershell to mount web application to Content database. Resulted into same error when I ran Mount-SPContentDatabase using powershell.

I tried checking SP versions and other things finally got solution in below way

Reason:
Once you have taken the backup from SharePoint 2013 content database, usually you will restore the database in the target SQL server.

After restoring the database, you will try to restore the content database at any one of Web application most probably new one. In this stage, you will get the above error message.

Solution:
Your source SQL server schema and the destination SQL server schema might not be matched. So you need to update the "Versions" table values in the "Restored Database".

1. Open "Versions" table from any of the existing "Content database"  from the Target SQL Server machine in "Select" mode.




2. Now open the "Versions" table values of "Restored Content Database" in "Edit" mode as mentioned below.


3. Replace the "Version" field value in "Restored Content Database" by "Existing Content Database" values from "Target SQL Server" machine.

4. Now you will be able to create new "Web Application".

That’s it..

Regards,

Keyur Pandya

Comments

  1. Unknown24 February 2021 at 19:00

    How will i know which version to change in the restored database?

    ReplyDelete
    Replies
    1. Keyur Pandya2 April 2021 at 11:20

      Version number varies, you might need to google based on your environment.

      Delete

Post a Comment

Popular posts from this blog

Business Data Connectivity

I came to a requirement wherein I was supposed to get data from an 3 rd party portal using API’s and then bring them to SharePoint server. The first approach that I finalized was just to make BDC solution that will get data from 3 rd party portal and will deploy it to SharePoint. How to Create BDC solution in SharePoint? I found below link that is having really great description about hot to create and deploy the BDC solution to SharePoint. http://www.c-sharpcorner.com/uploadfile/hung123/creating-business-data-connectivity-service-using-visual-studio-2010/ After creating an POC I came to know that BDC model cannot be deployed on Multi tenant farm. So what can be done next? After some amount of googling I came to know that we can create BDC solution using WCF services also. So I created a WCF service solution that acted as a wrapper that used to fetch data from the portal. We can them publish that service to IIS or Server and use the servic...
2 comments
Read more

OneDrive Sharing Report: A Comprehensive Guide

OneDrive Sharing Report Managing and monitoring the sharing permissions of files stored in OneDrive can be a critical task for organizations. This guide provides a step-by-step walkthrough of how to create an Azure AD application with specific permissions, generate a client secret, and use a PowerShell script to retrieve and report the sharing permissions of OneDrive files. By following these steps, you will be able to audit and control file sharing across your organization, ensuring security and compliance. Step 1: Creating an Azure AD Application To get started, you'll need to create an Azure AD application that will allow you to interact with the Microsoft Graph API and retrieve information about users' OneDrive files and sharing settings. Specifically, you need to set the following permissions: Directory.Read.All Directory.ReadWrite.All Files.Read.All ...
Post a Comment
Read more

SharePoint Server continuously prompting for Credentials

Sometimes it is the case when your SharePoint server keeps on prompting for credentials. After some amount of googling and going through some reliable blogs I found following solution. Open Run Type “regedit”.                                                                  In the registry window left panel find HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > LSA                                                                                                                      Now right clic...
3 comments
Read more