SQL Server Error: The database cannot be opened because it is version 852

Question

I am trying to restore databases from my backup .mdf, and .ldf files using MQ SQL Server Management Studio, but I getting the following error: "The database cannot be opened because it is version 852. This server supports version 706 and earlier. A downgrade path is not supported". How can I fix it?

Answer 1

Looks like your backup files are from SQL server 2016 and your current SQL server is 2012. You need to install SQL Server 2016 to fix the issue. Check the list of MS SQL server versions.