I'm trying to disentangle our backup strategy, and also troubleshoot the overnight backup of the Azure VM and of the SQL DBs to local storage on the Azure VM, via an agent job and maintenance plan. The VM is only used for the SQL DBs and storing associated load files.
The managed backup of the VM starts at 11am and completes in 5-7 hours - this possibly seems too long?
The SQL DB backup job starts at midnight and is taking 4+ hours to backup DBs totalling 1.15TB and the log file shows repeated Error: 18210, Severity: 16, State: 1 and Error: 3041, Severity: 16, State: 1 errors.
From looking at the successful backup log entries, there seem to be two backups going on - one with type=disk and another with type=virtual device.
My questions are:
Is the Azure VM managed backup also backing up the SQL DBs? Is it likely that overlapping this with a SQL DB backup likely to cause a clash in some way?