Share via

downgrade version compatibility issue while restoring a database

OPSC 1 Reputation point
2020-06-29T10:32:24.03+00:00

I have two servers. One with SQL Server 2017 and another with SQL Server 2012 and i set compatibility level to "SQL Server 2012 (110)" in SQL Server 2017.While restoring a database from SQL Server 2017 to SQL Server 2012, it shows me an error "The database was backed up on a server running version 14.00.2027. That version is incompatible with this server, which is running version 11.00.7001. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)". I am attaching the screenshot of the error.

10884-sql-server-2017-compatibility-level-setup.jpeg

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,651 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 85,816 Reputation points
    2020-06-29T11:08:42.51+00:00

    Hi,

    SQL Server is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

    You can ask the experts in the dedicated SQL Server forum over here:
    https://social.technet.microsoft.com/Forums/sqlserver/en-us/home?category=sqlserver

    (Please don't forget to accept helpful replies as answer)

    Best regards,
    Leon

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.