Tuesday, August 8, 2017

Azure Database For MySql - How to see the successful backup and restore logs?



I am using Azure Database for MySQL, vcore GpV2 and had opted for Geo-redundant backup during Database creation. According to the official documentation,




Generally, full backups occur weekly, differential backups occur twice
a day, and transaction log backups occur every five minutes.





But how shall I know whether backups are actually happening automatically? Where are the logs?



I checked in Activity Log but there aren't any backup logs coming.


Answer



There are no backup logs. The backup of PaaS databases is handled as part of the platform and the logs for this are not accessible to the user. The assumption is that if you are going to use a PaaS service that you trust the provider to do these things for. If you don't then you should run in IaaS.


No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...