Backups happen automatically as part of high availability commitment of the SQL PaaS Service. The capability provides 200% of the provisioned storage for backup free of cost. The retention period of the backup is based on the service tier. This can be extended up to 10 years using Long Term Retention policy (LTR)
- Basic service tier is 7 days.
- Standard service tier is 35 days.
- Premium service tier is 35 days.