Introduction
ShowsHappening database is an Azure SQL Database and stored in North Europe Azure data centre.
Point in time Backup
The Point in Time Backup database restore is set to 35 days.
Differential Time backups
Differential time backups are being taken every 12 hours.
Long Term Backups
Long term retention backups are taken weekly, monthly and yearly. Database Backup policy is shown in Figure 1.
Figure 1
Database Mirroring and Replicas
Database is continuously being replicated in another Azure data center location being West Europe for business continuity, as shown in Figure 2. Moreover, as will also be outlines underneath, Microsoft automatically maintains three replicases of the same data.
Figure 2