SQL transaction log backup fails

SUMMARY

SQL transaction log backup fails

ISSUE

Applies To

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) 

RESOLUTION

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.

CAUSE

A maintenance plan or another backup product did a backup of this SQL database in between our last full backup and this one.

NOTES

For more detailed information on backup failures and performance issues see Unitrends KB 5062 - Backup Failures and Performance Issues.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us