Veeam Backup: SQL Transaction Log Job Status

Veeam.Backup.SQLjobFailed.Monitor (UnitMonitor)

This monitor tracks state of the SQL transaction log backup job

Knowledge Base article:

Summary

A Veeam SQL Transaction Log Backup Job finished with issues.

Configuration

The monitor is enabled by default. You can override the following parameters:

Name

Default Value

Description

IntervalSeconds

900

Defines how often the monitor script collects the final job state. Due to high load on the backup server, a job may sometimes be reported to be finished before it changes its state.

Note: If you have configured several overrides of the same type, select the Enforced check box for an override that should have priority over all other overrides.

Causes

A Veeam SQL Transaction Log Backup Job may fail for various reasons, for example, due to failure to connect to the virtual infrastructure or because of some issue with the application-aware processing.

SQL transaction log backups require that specific permissions are granted to provide Veeam Backup & Replication access to the SQL server. A change to the required permissions was made in Backup & Replication version 9.5 Update 3a. The permissions required are listed in this Veeam KB article.

Resolutions

Check the error message reported by the backup server. If there is no direct indication about the issue, check Veeam Online Knowledge Base for possible solutions. If there is still no relevant information, please submit a support ticket with detailed information about the issue and backup log files. It is recommended that you send the whole content of the log folders to ensure that overall and comprehensive information is provided to the support team.

Use the Alerts View to see all current open issues for this object. Use the Events View to review any error and warning events for this object. Open a Performance View to see the performance metrics for this object and all contained objects. Open a Diagram View to analyze the relationships of this object to other components.

External

Check the Veeam Backup & Replication resources for more information, in particular:

Community Forums

Online Knowledge Base

Technical Documentation

Element properties:

TargetVeeam.Backup.SQLTransactionLogJob
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityHigh
Alert Auto ResolveTrue
Monitor TypeVeeam.Backup.SQLjobFailed.3StateMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
Veeam Backup: SQL Transaction Log Job Status
{0}
RunAsDefault