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

Question

I tried to restore a database but this message showed  How do I restore this database      Restore of database  farhangi db  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

User · Accepted Answer

Originally  I created a database and then restored the backup file to my new empty database      Right click on Databases   Restore Database   General   Device   the   path of back up file    OK   This was wrong  I shouldn t have first created the database   Now  instead  I do this      Right click on Databases   Restore Database   General   Device   the   path of back up file    OK

User · Answer

In my case I am restoring a SQL Server 2008 R2 Database to SQL Server 2016 After selecting the file in the General tab  you should go to the Options tab and do 2 things         You must activate Overwrite existing database   You must deactivate end of record copy

User · Answer

I fixed my error on restoring to non-existing DB from SQL 2008 to SQL 2014 by putting a check mark on Relocating to the new SQL2014 folder location

User · Answer

I just deleted the existing DB that i wanted to override with the backup and restored it from backup and it worked without the error

User · Answer

In our case it was due to the Recovery Model on the primary database having been changed after we did the backup in preparation for setting up log shipping   Ensuring the Recovery Model was set to Full Recovery before doing the backup and setting up log shipping resolved it for us

User · Answer

Please see below image and apply changes in SqlServer    first right click on Database --  Task --  Restore --  Select Backup File --   Finally Apply Change in Options Tab

User · Answer

In case the problem still exists go to Restoration Database page and Check  Restore all files to folder  in  Files  tab This might help

User · Answer

Click Right Click On Your Database The Press tasks Back Up  and take a back up from your database before restore your database i m using this way to solve this Problem

User · Answer

I am not sure whether the database backup file  you trying to restore  is coming from the same environment as you trying to restore it onto   Remember that destination path of  mdf and  ldf files lives with the backup file itself   If this is not a case  that means the backup file is coming from a different environment from your current hosting one  make sure that  mdf and  ldf file path is the same  exists  as on your machine  relocate these otherwise    Mostly a case of restoring db in Docker image   The way how to do it  In Databases -  Restore database -   Files  option -   Check  Relocate all files to folder  - mostly default path is populated on your hosting environment already

User · Answer

Another cause of this issue is when the Take tail-log backup before restore  Options  setting is enabled    On the  Options  tab  Disable uncheck Take tail-log backup before restore before restoring to a database that doesn t yet exist

User · Answer

You can use following SQL to restore if you ve already created database  RESTORE DATABASE  YourDB  FROM DISK    C  YourDB bak  WITH MOVE  YourDB  TO  C  YourDB mdf   MOVE  YourDB Log  TO  C  YourDB ldf   REPLACE

User · Answer

Simply you can use this method    If you have a database with same name  WIN R -  services msc -  SQL SERVER MSSQLSERVER  -  Stop Go to your MySQL Data folder path and delete previews database files Start sql service  Right click on database and select Restore database in Files tab change Data file folder and Log file folder  Click on OK to restore your database   my problem was solved with this method BY

User · Answer

Make sure there is a new database  Make sure you have access to your database  user  password etc   Make sure there is a backup file with no error in it    Hope this can help you

User · Answer

Another cause for this is if you have the same database restored under a different name  Delete the existing one and then restoring solved it for me

[sql-server] BACKUP LOG cannot be performed because there is no current database backup

Examples related to sql-server