All geek questions in one place

Error restoring backup file on SQL Server 2012

I have a compatibility problem when trying to restore a database backup that is running on SQL Server 2014. But I have SQL Server 2012. Please help me solve this problem.

Below is the error message

enter image description here

+4
source share
3 answers

The best way is to create script fileand execute it on the required server. When creating the Server Select versionSql2012

+2
source

You cannot downgrade. It's impossible.

+1
source

Restoring a backup made in higher versions and restoring it to lower versions is not possible. you need a script to output tables and run them in 2012, you should also consider any 2014 functions that may not work in 2012.

below are the steps

right click on the database -> tasks-> generate scripts

enter image description here

select entire database

enter image description here

in the next step, click "Advanced" and change the properties below

enter image description here

permanently save

enter image description here

you can also use export data as below

enter image description here

+1
source

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

More articles:


All Articles