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

I got the following error:

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

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

When I tried to take a log Backup via Management Studio by doing the mentioned steps below:

  • Right-click on the database name.
  • Select Tasks > Backup.

Back up Steps.png

  • Select “Transaction Log” as the backup type.
  • Select “Disk” as the destination.
  • Click on “Add…” to add a backup file and type “C:\SharePoint_Config.Bak” and click “OK”.
  • Click “OK” again to create the backup.

BackUp log from SSMS

When I clicked OK. I got the this error.

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

Also, I tried to use BACKUP LOG T-SQL

BACKUP LOG SharePoint_Config TO DISK = 'C:\SharePoint_Config_log.bak' 
GO

But unfortunately, I got the same error result.

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

Cause :

This error occurs because of performing a log backup before performing a full database backup as a mandatory prerequisite for performing a log backup operation.

Solution:

*Via T-SQL:

I will apply a bundle command to take a full database backup and log backup at once.

BACKUP DATABASE [SharePoint_Config] TO DISK = N'C:\SharePoint_Config.bak'
GO
BACKUP LOG [SharePoint_Config] TO DISK = N'C:\SharePoint_Config_log.bak'
GO

**Via SSMS:

1. Full Database Backup

  • Right-click on the database name.
  • Select Tasks > Backup.

Back up Steps.png

  • Select “Transaction Log” as the backup type.
  • Select “Disk” as the destination.
  • Click on “Add…” to add a backup file and type “C:\SharePoint_Config.Bak” and click “OK”.
  • Click “OK” again to create the backup.

full back up database.png

2. Transaction Log Backup.

  • Again, Right-click on the database name.
  • Select Tasks > Backup.

Back up Steps.png

  • Select “Transaction Log” as the backup type.
  • Select “Disk” as the destination.
  • Click on “Add…” to add a backup file and type “C:\SharePoint_Config_log.bak” and click “OK.”
  • Click “OK” again to create the backup.

BackUp log from SSMS

Enjoy 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s