User Tools

Site Tools


Sidebar

Announcement

Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize

License

Documentation

Performance Testing

FAQs and Known Issues

Can't Find What You Need?

public:5293_backuplog_cannot_be_performed_no_current_database_backup

ISSUE: BACKUP LOG cannot be performed because there is no current database backup (MS SQL transaction log backup)

Article ID: 5293
Reviewed: 24/01/2018

Product Version:
AhsayOBM: 7.15.2.0 or above
OS: Windows

Problem Description

When performing a MS SQL transaction log backup (ODBC backup mode), the following warning message is received in the backup report:

No. Type Timestamp Log
* ... ... ...
* info ... [Start] Backing up "SQL_hostname\MSDB\db_name" using "Transaction log" to "temp_path"
* warn YYYY/MM/DD hh:mm:ss [Microsoft][ODBC SQL Server Driver][SQL Server] BACKUP LOG cannot be performed
because there is no current database backup.
* ... ... ...

Cause

This error can occurs if there is no full backup performed before a transaction log backup.

This error can also occurs when the database recovery model had been changed (e.g. from Full to Simple or vice versa) but a Full backup was not performed since the change (Details).

Resolution

To resolve the issue, perform a Full database backup before performing a transaction log backup.

If a full backup has been performed, the following conditions will require that another full backup be taken:

  • The recovery model had been changed without taking a full backup.
  • A SQL maintenance plan task had changed the recovery model (re-indexing can cause this).
  • The database was detached from another server and attached to the current server.

Keywords

sql, odbc, log, differential, database, mssql, recovery, model, transaction

public/5293_backuplog_cannot_be_performed_no_current_database_backup.txt · Last modified: 2018/02/02 13:29 by edward.chan