Adding SQL2014 Sharepoint DB to Sharepoint Portal 2013

Question

Hi all,

I am having a problem while adding SQL 2014 database to Sharepoint portal 2013. Scenario is previously we are using SQL 2008 Server with Sharepoint Portal 2013, We have now upgraded SQL Server to 2014. I have multiple Sharepoint Site databases on 2008 sql server from where i backup and simply restore to the new sql server 2014. after that attach it to the Sharepoint web application. on few of the databases i got an error while attaching to the Sharepoint web application

Mount-SPContentDatabase : Sequence [Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence] cannot upgrade an object [SPContentDatabase Name=DB_Compliance] whose build version [12.0.0.6421] is too old. Upgrade requires [14.0.4762.1000] or higher.

Experts please help me to out to solve this issue.

Regards,
Sarfraz

Answer 1

Hi @Sarfraz Aslam ,

Per my understanding, this error message means that the SharePoint version builds may be too low and need to be upgraded to [14.0.4762.1000] or higher. You can also try to check the error logs to see if there are more error messages.

You could try to install SharePoint 2013 SP1 to test if it solves the issue:
Steps for upgrading sharepoint 2013 to service pack1

References:
SharePoint 2013 Build Numbers and CU’s

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Since the database is at version 12, you first need to update the database to SharePoint 2010. You need to match the edition (Server Standard, Server Enterprise) of the edition of SharePoint Server 2007 used.

Attach the database to a SharePoint 2010 farm which should upgrade the database during the attach process. Detach the database then attach it to a 2013 farm (again, same edition of SharePoint) which should in turn upgrade the database.

Don't forget to convert to claims (Convert-SPWebApplication) and upgrade each Site Collection (Upgrade-SPSite).