Does Azure Database for MySQL Server keep transaction log backups? Where can they be checked?

Question

Good morning to everyone,

I would like to have some answer on a doubt that I cannot solve using Microsoft documentation, which I have read at those pages:

https://learn.microsoft.com/en-us/sql/relational-databases/logs/the-transaction-log-sql-server?view=sql-server-ver16

https://learn.microsoft.com/en-us/azure/mysql/single-server/concepts-backup

In my company we have Azure Database for MySQL Server which keeps a full backup every single day and retains them for 35 days. In the second link I provided, I can read that:

Transaction log backups occur every five minutes

In the first link, however, I see that the transaction log applies only to SQL Servers (Which I did not know was different from the Azure Database for MySQL Server).

So I am a bit confused now. Is my Azure Database for MySQL server keeping track every five minutes of transaction logs? If yes, is it saving it in a particular location?

What is the main difference between transaction log backups and bulk logged recovery backups - which is, again, only available in SQL Servers?

I would like to thank you in advance,

Answer 1

Hi @Michele

Here is an information about automated backup for Azure MySQL

Is my Azure Database for MySQL server keeping track every five minutes of transaction logs?- Yes, here is snippet and reference link https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore

If yes, is it saving it in a particular location?

By default, Azure Database for MySQL server backup storage is locally redundant for servers with same-zone high availability (HA) or no high availability configuration, and zone redundant for servers with zone-redundant HA configuration.

Let us know if you have any additional questions.

Thank you!

Answer 2

Thank you so much, it is now clear.