SQL transaction log backup fails
SQL Transaction log backup
Symptoms / Description
SQL Full backups are successful, but transaction log backups fail;
Windows Event ID 263 from source “Unitrends Agent” with summary (id 3340) session completes. Failed to send summary. Error returned 0xffffffff;
The WBPS log on the client, c:/PCBP/Logs.dir, shows the following message:
ERROR!!! Backup was taken outside of Unitrends SQL Agent, or agent can not validate sql checkpoints for differential and transactional backups.
Excerpt from c:\pcbp\logs.dir\WBPS_01.log_j145628.err S Q L G R O U P B A C K U P I N F O Instance: \test_SQL DataBase: test_db _____________________________________________________________ Start date | Status | Type |VSS _____________________________________________________________ 2019-04-05 13:01:53.000|COMPLETE |FULL |Yes _____________________________________________________________ - DPU :Unitrends_VSS - Client :test_SQL ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ _____________________________________________________________ 2019-04-05 14:00:01.000|UNKNOWN |LOG | No _____________________________________________________________ - ERROR :Backup was taken outside of Unitrends SQL Agent - Device :D:\backups\SQL_dumps\test_db_backup_2019_04_00_000001_1468476.trn
Error above lists native log truncation (may also see full dump of SQL DB instead)
Disable maintenance plans, and re-run a new SQL full of the database in question, or
Switch both the maintenance plans and the DPU backups to do SQL Fulls only.
A maintenance plan or another backup product did a backup of this SQL database in between our last full backup and this one.
For more detailed information on backup failures and performance issues see Unitrends KB 5062 - Backup Failures and Performance Issues.