Skip to main content
SQL log backups fail with error SQL8
Updated over a week ago

Problem description

Before the schedule for the log backup kicks in, at least one database is in the full recovery model, and the permissions to perform a log backup are correct. However, the log backup fails with error SQL6 (No database found for backup).


In rare situations, changing the recovery model type from full to simple or vice versa before or during the backup window causes this error.


The event viewer will have the following error:

event viewer error.jpg

The database configuration is as follows:

DB properties.jpg

The backup job will fail with the following errors:

[2020-05-14 02:51:29,529] [ERROR] <_MainThread(MainThread)> Exception: BACKUP LOG cannot be performed because there is no current database backup. (#100030008) (Error Code : SQL8).

[2020-05-14 02:51:29,529] [ERROR] <_MainThread(MainThread)> Error <class 'inSyncLib.inSyncError.SyncError'>:BACKUP LOG cannot be performed because there is no current database backup. (#100030008) (Error Code : SQL8). Traceback -Traceback (most recent call last):

File "agentPartnerProcess.pyc", line 157, in _process_request

File "agentPartnerProcess.pyc", line 85, in _process_request_start

File "agents\sqlserver\SqlAgent.pyc", line 62, in process_backup_start

File "agents\sqlserver\SqlBackup.pyc", line 256, in prepare

File "agents\sqlserver\SqlBackup.pyc", line 234, in __discover_databases

File "agents\sqlserver\VssHelper.pyc", line 824, in discover_databases

File "agents\sqlserver\VssHelper.pyc", line 1066, in check_backup_status

SyncError: BACKUP LOG cannot be performed because there is no current database backup. (#100030008) (Error Code : SQL8)


Examine the SQL server logs to check if the following sequence of events exists.

main_error (2)_LI.jpg

If you notice a change in the recovery model such as SIMPLE followed by FULL, then the issue is caused due to the cause explained in this article.


  • When a SQL Server database has a LOG BACKUP schedule, and the Recovery Model changes from FULL to SIMPLE, then upon changing back to FULL, A FULL BACKUP must occur to start a new log backup chain.

  • Since, in most cases, a FULL backup is only scheduled once a day, the log backup continues to fail until a FULL backup happens, and after that, if the recovery model is changed again, then the issue repeats itself.

  • Please check with your DB administrator or the user who keeps changing the recovery model of the affected DB’s. Ideally, the recovery model should remain unchanged.

  • If there are unavoidable environmental requirements, check with your DB admin for a time window when he changes the recovery model and can schedule a FULL backup after it. Running a full backup creates a new log chain, but you will still see log backup errors until the FULL backup completes.

  • If the recovery model of a database needs to be changed for some reason, create another backup set for this SQL server. After the changes, only the backups for this backup set will fail, and the other backups will be unaffected.

📝 Note
Before creating a new backup set for this database, deselect this database from the current backup set.

Did this answer your question?