CODEWITHSUNDEEP
sql-serverdatabase-restore
hmahdavi
hmahdavi

Reputation: 2352

How to restore SQL Server 2014 database backup to a SQL Server 2016?

I get backup of my 2014 version database and try to restore this in another server into database with same name and login. This SQL Server version is 2016.

When restoring the backup file, I get this error:

TITLE: Microsoft SQL Server Management Studio

Restore of database 'TravelEnterDB' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: BACKUP LOG cannot be performed because there is no current database backup. (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=13.0.16106.4+((SSMS_Rel_16_5).170125-2137)&LinkId=20476

I first created this database in SQL Server 2016 and then tried to restore backup file.

I can restore this backup file in SQL Server 2014 currently.This file has no problem!

What is problem?

enter image description here

Upvotes: 2

Views: 7862

Answers (1)

Stewart Allen
Stewart Allen

Reputation: 66

as noted by hmahdavi this works. "check " with replace " and uncheck " Tail log backup " restored successfully"

Upvotes: 5

Related Questions