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.

Untitled.png

                                                               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.

Screenshot 2023-05-10 090838.png

                                                               Figure 2