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

 Today i have faced one issue while mount content database to server.

the issue is "This content database has a schema version which is not supported in this farm."

I was getting this error when i ran Mount-SPContentDatabase using powershell. 

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

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 content database in any one of Webapplication most probably new one. In this stage, you will get the above error message.

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

Thats it..

Source : 


Post a Comment

Popular posts from this blog

Announcement WebPart using XSLT

Programmatically upload a Document to SharePoint Library

SharePoint 2013 list column status wise Change row Color using jQuery