All geek questions in one place

Failed to restore SQL Server database - Version conflict

I am trying to restore SQL Server database backups from files *.bak, and whenever I try to restore using Microsoft SQL Server Management Studio, I get the following error:

Error restoring database "ALA_PPD".
(Microsoft.SqlServer.Management.RelationalEngineTasks)

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The database has been copied to the server with version 12.00.2000. This version is not compatible with this server running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup compatible with this server. (Microsoft.SqlServer.SmoExtended)

I understand that the versions of the servers, where they are different, are my question - is there a way to convert these 12.00.2000 *.bakfiles that can be used in version 11.00.2100?

I know that I can install ver. 11.00.2100 and successfully recover, but I have databases in my installation 12.00.2000 that cannot be deleted.

Any suggestions would be greatly appreciated. Sorry if this is a question about noob.

+4
source share
1 answer

: / / (SQL Server 2014 - v12.0) SQL Server (SQL Server 2012 - v11.0). , .

  • SQL Server - /

  • (, , ..) ( , ) SQL Server Management Studio (Tasks > Generate Scripts),

  • , Red-Gate SQL Compare SQL Data Compare, "" , , ; SQL Server.

+9

Source: https://habr.com/ru/post/1611852/

More articles:


All Articles