+2 votes
in Databases by (63.4k points)

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?

data restore error sql server

1 Answer

+1 vote
by (271k points)
selected by
Best answer

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.

MS SQL server versions