why does SQL transaction log taking too long after enabling the backup policy?

[manatee]

NBU 7.6.0.3

we did upgrade of SQL Server over the weekend and during that time i have to disable the backup policies for SQL. included in that backup policies are the policies for transaction logs that occurs every 15 minutes.

when the upgrade of SQL server is done, i reactivated the backup policies. the policy for the database backup ran immediately because the backup window is already upon us. but the backup for the transaction logs (there are 2 of them) didn't run immediately. one ran after 9 minutes while the other is scheduled to run after 12 hours!

i don't want to run it manually as i know i have to issue the CLI command again to set it to 15 minutes interval. the question is, why do transaction log backups take hours to resume?

[Michael_G_Ander]

Could be caused by the retry option in Master properties, which is default 2 tries per 12 hours.

[Marianne · Accepted solution]

Impossible for anyone to say without having any insight into Policy config and Global Settings.

Next time you see perceived abnormal behaviour, please post Policy output for at least one Policy misbehaving (bppllist <policy-name> -U) and nbpemreq output.