Skip to main content


 

 

How can we help you?

 

 
Druva Documentation

SQL log backup completes with “Successful with errors”

Heads up!

We've transitioned to a new documentation portal to serve you better. Access the latest content by clicking here.

 

Problem description

SQL log backup completes with “successful with errors”. One or more databases are skipped from the log backup

Cause

The database(s) were recently restored hence they got skipped from the log backup

Traceback

  1. Follow the instructions provided in the link below to obtain job logs.
    How to collect the detailed job logs
  2. Extract the logs and go to Phoenix<YYYYMMDD>_<timestamp>.log file to see the below traceback in the logs.
    [2022-09-07 04:09:48,332] [INFO] <_MainThread(MainThread)> Already restored <Instace_name>:<database_name> 

Resolution

  1. Log on to the SQL server which hosts the SQL instance
  2. Connect to the SQL Server Management Studio
  3. Execute the query to find out restore history of the database which is skipped from the log backup
    select * from msdb.dbo.restorehistory where destination_database_name like '%<database_name>%'
    Reference : restorehistory (Transact-SQL)
    The output will show the information about the database restoration activity
  4. Run a manual backup from Phoenix console which will perform a differential backup after which the log backups for these databases will start working fine
  • Was this article helpful?