UserErrorOtherBackupProductCausingSQLLSNValidationFailure after June 1st, 2021

Question

Hi

On June 1st, 2021 around 08:25 GMT log backup of SQL Server logs on one of our VMs started failing with:

Error Code
UserErrorOtherBackupProductCausingSQLLSNValidationFailure

Error Message
Log chain is broken, as another backup product is taking backups.

Recommended Action
Please trigger a full backup to fix the issue. This typically happens when a log backup is taken by some other backup, so to avoid this issue in future follow the below steps:

1. If you are using some other software to do SQL backup or using SQL native backup please disable it.
2. If you have configured Azure IaaS VM image backup using Azure Backup service, please make sure that VM backup is using VSS copy.

---

This happens for all DBs.

As far as i know we didn't change anything on the VM or the Recovery Service Vault, and according to the SQL Server logs, only Azure is taking backup of the DBs.

I've tried triggering a manuel full backups (the full backup works), but the log backup fails with the same error after a very short time. I've tried this multiple times for each DB.
I've tried manually uninstalling "Azure Workload Backup" and re-registering it from the Recovery Service Vault (which caused it to reinstall as expected). But it didn't solve anything.

Does anyone have any ideas on what to try next?

Answer 1

Hi @SadiqhAhmed-MSFT

And thank you for your answer.

The issue resolved itself on Saturday, June 5th (without us changing anything) and it has worked flawlessly since.

Thank you for your help, I'll make sure that the Azure managed SQL backup is disabled on all databases to make sure this issue will not arise again in the future.