AhsayCBS (DIY)Transaction Log Backup Fails: No Full Backup Found for MS SQL Database
April 16, 2025
Product Version
AhsayOBM: 7 and above
Operating System
Windows
Symptom
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 | YYYY/MM/DD hh:mm:ss | [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.
