Azure VM SQL Server Automated Backup doing log backups only
1
vote
0
answers
40
views
We have an Azure VM running our own copy of SQL Server 2019, and we have just configured the Automated Backup functionality.
I have it configured like this:
Everything seems to be fine, except for the fact that we do not seem to be getting any full backups. I have checked our storage account in the backup container, and we have all the expected logs for each user database, but no trace of any full backups.
Configuration seems pretty straightforward, so I can't see anything wrong here. I have also checked various logs on the VM for both Windows and SQL Server itself, and I can see the log backups from the Automated Backup happening, but no reference to full backups or any errors or warnings that might indicate something is wrong.
Any ideas?
Everything seems to be fine, except for the fact that we do not seem to be getting any full backups. I have checked our storage account in the backup container, and we have all the expected logs for each user database, but no trace of any full backups.
Configuration seems pretty straightforward, so I can't see anything wrong here. I have also checked various logs on the VM for both Windows and SQL Server itself, and I can see the log backups from the Automated Backup happening, but no reference to full backups or any errors or warnings that might indicate something is wrong.
Any ideas?
Asked by Crogacht
(11 rep)
Sep 9, 2021, 09:25 PM