1

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:

Automated Backup configuration

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?

Improve this question
2
  • 1
    Are there log backups at 1 AM?...Are you sure the server is online / awake at 1 AM? Commented Sep 10, 2021 at 4:02
  • Have you queried msdb.dbo.backupset to see if the backups are being performed? Commented Sep 10, 2021 at 12:22

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.