All geek questions in one place

Can we restore a backup of SQL Server 2008R2 to SQL Server 2014?

One of our products is currently running on SQL Server 2008R2.

For the new installation client, you need to upgrade to SQL Serer 2014 because at this point Microsoft does not sell the license for SQL Server 2008R2.

+6
source share
3 answers

In SQL Server 2014, you can restore a user database from a database backup that was created using SQL Server 2005 or later . However, master, model, and msdb backups created using SQL Server 2005 through SQL Server 2012 cannot be restored by SQL Server 2014. In addition, backups created in SQL Server 2014 cannot be restored using an earlier version of SQL Server

A source

+11
source

Yes.

If you restore a database backup created with an older version of SQL Server to the new version, SQL Server will automatically update your database in the new version. But do not change the compatibility level of your database. You can change the compatibility level of your database after recovery is completed with the following query:

ALTER DATABASE test SET COMPATIBILITY_LEVEL = 120
+4
source

In SQL Server 2014 SP1 , changes to the restoreheader definition occurred (3 new fields added). If you use it, you should take a look at this topic: breaking changes in SQL Server 2014 SP1 - restoreheader

0
source

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

More articles:


All Articles