NetWorker NMM SQL Log backups are promoted to FULL after AG failover
Summary: NetWorker NMM SQL Log backups are promoted to FULL after AG failover.
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
NMM SQL AG log backups are promoted to level FULL after a failover. The following messages are seen in the 'nsrsqlsv.log'
<<date-time>> (pid13152) NSR info SQL Connection to <SQL-Instance> is created. SQL Server Version is 13.00.5026
176964:(pid 13152): Log gap detected in incremental backup for AAG database [<Database>].
This backup of [<Database>] will be promoted to a full database backup.
The backup time increases as the backup is promoted to FULL.
Cause
The backup promotion to level FULL occurs because after failover, there is a break in the LSN for the AG database recorded in the msdb of the new SQL host.
Resolution
Backup with the parameter Backup_promotion=none in the backup command
Affected Products
NetWorkerProducts
NetWorkerArticle Properties
Article Number: 000078837
Article Type: Solution
Last Modified: 18 Apr 2026
Version: 6
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.