I understand that we have a limit of 50 on demand backups per server. But since the backups have a 7 day retention, does that mean as these backups drop off, that count is restored back? Let's say I run 5 on demand backups on a certain day. This leaves me with 45 more. After 7 days they drop off. Will I then have 50 again?

Hi @Mike Huffman 50 is the on-demand backup limit per server. You will not be able to trigger on-demand backup once limit of 50 is reached. Yes, these on-demand backup’s are stored it in alignment with server’s backup retention policy and will be automatically deleted as soon as they fall off the server retention period window. Thank you!

On demand backups for MySQL flexible server. 50 limitation question.

Accepted answer

Rahul Randive 8,751 Reputation points Microsoft Employee

2024-02-29T20:54:57.7266667+00:00

Hi @Mike Huffman
50 is the on-demand backup limit per server. You will not be able to trigger on-demand backup once limit of 50 is reached. Yes, these on-demand backup’s are stored it in alignment with server’s backup retention policy and will be automatically deleted as soon as they fall off the server retention period window. Thank you!
Please sign in to rate this answer.
Mike Huffman 20 Reputation points

2024-03-02T18:50:48.2233333+00:00

I'm already aware of the 50 limit, that wasn't my question. When the on-demand backup expires, do I recoup that count? That is my question. I ran one last Friday, so I guess this coming Friday I'll know the answer since the retention is 7 days.

Rahul Randive 8,751 Reputation points Microsoft Employee

2024-03-04T17:54:36+00:00

Hi Mike Huffman,

Thank you for your comment. I've also included the following details in my response, which you may have missed.
As mentioned, "You won't be able to trigger on-demand backups once the limit of 50 is reached. Yes, these on-demand backups are stored in alignment with the server's backup retention policy and will be automatically deleted when they fall off the server's retention period window.

To answer your question, yes, as the on-demand backups drop off after the 7-day retention period, the count is restored back. So, if you run 5 on-demand backups on a certain day, you'll have 45 more backups remaining for that server. After 7 days, when those 5 on-demand backups drop off, you'll have 50 on-demand backups available again for that server.

Hope this help! Let me know if you have any additional questions.

Thank You!

Rahul Randive 8,751 Reputation points Microsoft Employee

2024-03-05T02:28:16.9433333+00:00

Hi Mike Huffman,

I have double-checked with the product team, and they confirm that "yes, when on-demand backup expires, you recoup the count." However, I will await your testing results, and I hope they align with the information I have provided.

Thank You!

Rahul Randive 8,751 Reputation points Microsoft Employee

2024-03-09T13:41:08.62+00:00

Hi Mike Huffman,
Hope you are doing well.

Just checking if there's any progress or updates?
Thank You!

Rahul Randive 8,751 Reputation points Microsoft Employee

2024-03-11T19:15:22.09+00:00

Hi Mike Huffman,

I hope the testing results are expected. If you find any discrepancies, please let me know, and we can review them together. Looking forward to your response.

Thank You!

Mike Huffman 20 Reputation points

2024-03-13T16:30:09.9033333+00:00

Confirmed. The count is recouped after the on-demand backup expires.

Rahul Randive 8,751 Reputation points Microsoft Employee

2024-03-13T16:42:38.98+00:00

Hi Mike Huffman,

Awesome! Thanks for the confirmation and thank you for visiting Microsoft Q&A.
Sign in to comment

Share via

On demand backups for MySQL flexible server. 50 limitation question.

0 additional answers