I am migrating my databases to my new server and encounter this error when trying to attach. "This content database has a schema version which is not supported in this farm."
At first you run Test-SPContentDatabase to see if you're missing fetures or site definitions. If you do, you need to install the solutions and site definitions that are missing.
Test-SPContentDatabase -name "WSS_Content" -webapplication http://sitename -ServerInstance "SQL2"
When you have a successful run of Test-SPContentDatabase, you run Upgrade-SPContentDatabase, which will migrate the database schema of your content database to the 2016 farm schema.
When your database is upgraded, mount it using the cmdlet Mount-SPContentDatabase.
This issue occurs when the build number of your
destination farm is not identical (lower) to the build number of the source farm.
So to solve this issue,before you take a backup of content database from source farm , you should match the
Configuration database version of destination farm to be the same as the source farm by following the mentioned steps below:
- Get the
build numberof your source and destination farm ,
- Check which farm has a higher build number , and install it to the lower build number farm.
- Now make sure that the build number at the source and destination farm is identical.
- Get a backup from source , attach it to the destination , mount it to the destination . via PowerShell
Mount-SPContentDatabase "<ContentDb>" -DatabaseServer "<DbServer>" -WebApplication http://SiteName
I wrote about this issue in more details at This content database has a schema version which is not supported in this farm