SQL Server 2016 Msg 3169 How to solve restore Sql Server 2016 to 2104 with compatibility mode 110

Navigation
0

SQL Server 2016 Msg 3169 How to solve Sql Server 2016 to 2104 with compatibility mode 110.

Error:

Msg 3169, Level 16, State 1, Line 38 The database was backed up on a server running version 13.00.4001. That version is incompatible with this server, which is running version 12.00.5532. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. Msg 3013, Level 16, State 1, Line 38 RESTORE DATABASE is terminating abnormally. An error was encountered during execution of batch. Exiting.

    
asked by anonymous 22.04.2017 / 21:07

1 answer

0

Alexandre, the error message explains the cause: can not restore the backup (of the database), generated in instance with SQL Server 2016 (build 13.00.4001), in the instance with SQL Server 2014 (build 12.00. 5532).

What you are trying to do is called database version downgrade . For this, there are a few options:

  • generate export script using Management Studio;
  • SQL Server Integration Services;
  • create export and import scripts.

Suggested reading: How to migrate to SQL Server database to a lower version

On the web there are several pages on the subject; I suggest you search for sql server downgrade database .

    
24.04.2017 / 23:35
Git merge on windows conflict occurs and the line in the file is not marked How to compare the password through a wordlist