Both Azure Platform and .Net 6: create a backup on deman of a MySql\PostgreSql\Sql Server DB

Question

Hi,
is there a way on Azure Platform to make an instant backup of a mysql\postgres\sql server database?
I need to create a backup, immediately after the database creation (or a little later anyway).
Retention period starts from 7 days. There is not a parameter for "Start Now".

I need to do this also by code, with .Net 6.
Can you recommend me a method from the azure sdk? I searched a lot, but found nothing.

Thanks,
Francesco

Answer 1

Hi, @Franz Thanks for the ask and for using the Microsoft Q&A platform.

For MySql, We have an on-demand backup which is in our roadmap, we don't have any ETA yet.

On the Postgres SQL, there is no offer as such however you can always do a logical backup for instance with pg_dump

For Azure SQL DB, there are no plans to allow invoking a database backup on demand. However, the built-in backup and restore mechanisms already allow a precise point-in-time restore within the specified retention period. you mentioned 7 days of retention – it should be noted that 7 days is not the start time for the first backup.

Please let me know if this information is helpful

Regards
Geetha