Zooming in on backup and restore
Backup and restore processes are also part of the broader disaster recovery picture. However, you might end up with a corrupted database or accidental data deletion, even in a non-disaster situation:
Figure 3.16 – Zoom-in on backup and restore
Figure 3.16 is far from being comprehensive, but it should give you the key aspects to consider for a good backup and restore strategy. Figure 3.16 includes four top-level groups:
- NON-DB PAAS: This top-level group refers to managed services that are not related to database engines.
- ON-PREMISES/CLOUD VM: This is applicable to both on-premises and cloud-hosted virtual machines.
- STORAGE ACCOUNTS: AzCopy is usually used to push and pull data to/from storage accounts.
- PAAS DB: This top-level group relates to database-specific managed services.
We first distinguish database services from other PaaS services, because the way to back up and restore them is...
