Share via

MySQL Flexible Server Backup Long Term Backup Retention

Philip Lewis 51 Reputation points
2023-10-04T11:11:05.8566667+00:00

Hi

Deleting a MySQL flexible database will lead to the deletion of all the backups..

With other database backup flavours, it is possible to set LTR on the backups. Is there a plan to add this functionality to the flexible server backup offering soon?

Thanks

Phill

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
771 questions
Accepted answer
  1. Rahul Randive 9,176 Reputation points Microsoft Employee
    2023-10-04T11:31:41.94+00:00

    Hi Philip Lewis •

    Please find FAQs document related to Backup/restore for MySQL - Flexible Server and answers to your question.

    https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore#frequently-asked-questions-faqs

    What happens to my backups if I delete my server?

    If you delete the server, all backups that belong to the server are also deleted and cannot be recovered. 

    Can I configure automatic backups to be retained for long term? 

    No, currently we only support a maximum of 35 days of automated backup retention. You can take manual backups and use that for long-term retention requirement.

    Let us know if you need any additional information.

    Thank you!

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,481 Reputation points Microsoft Employee
    2023-10-04T11:41:21.41+00:00

    Hi
    Philip Lewis    ,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you want to know if there is a plan to add this functionality to the flexible server backup offering in Azure Database for MySQL Flexible Server.

    Long-term retention (LTR) leverages full database backups to enable point in time restore (PITR). It can be beneficial for you to employ LTR for several reasons, such as auditing, compliance, or data archiving. Azure Database for MySQL (both Flexible Server and Single Server) offers a retention period up to 35 days, but there may be situations in which you want to retain the backups for longer periods. Azure offers a variety of alternatives for retaining backups for longer than 35 days.

    Refer to this Blogpost

    Azure Database for MySQL: Extending Long Term Retention by using containers which states how we can configure LTR for your database backups for periods longer than the 35 days provided for in Azure Database for MySQL.

    Also, keep visiting our "What's New" /"Roadmap" page https://learn.microsoft.com/en-us/azure/mysql/flexible-server/whats-new for latest launched features in the product.

    We also encourage you to raise your valuable feedback over the Azure Database for MySQL Feedback Channel so that concerned team could work on the feature depending upon the importance and up-votes.

    Hope this helps. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

    Thank you.

    0 comments
  2. Philip Lewis 51 Reputation points
    2023-10-11T11:13:32.31+00:00

    So the documentation which I'd already seen says flexible server backups are deleted when the database server instance is deleted. Which is what prompted my question. It is not possible to configure LTR on the backups from flexible server instances. ShaktiSingh suggested raising this as an idea for the product team which I have.

    0 comments