Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
1.8k views
in SQL Server by 21 20 26
edited by

In SQL Server Management Studio I want to restore a database backup where I have a database file NES.bak
So first I have created a new database which takes the same name then I select "restore the database" and specify the path of the database but  I got this error 

BACKUP LOG cannot be performed because there is no current database backup


1 Answer

0 like 0 dislike
by 159 200 385
selected by
 
Best answer

BACKUP LOG cannot be performed because there is no current database backup

You have two options to restore a database backup without getting this error.

  1. Try to restore the database from your backup without creating a new database that should be working properly.

BACKUP LOG cannot be performed because there is no current database backup

  1. or Take a full database backup from the newly created database before performing the database restore.

You might also like to read

If you don’t ask, the answer is always NO!
...