BACKUP Policy and Recovery Service Vaults in Azure with Real-Time Example
Recovery Service Vaults :The ASR RSV and Azure Backups will be deployed to separate resource groups as per the table below.
Virtual Machines will be backed up with the Azure native backup service. Backups will be stored in an Azure Recovery Service Vault stored in the same region as the VMs being backup up. The Recovery Services Vault will be replicated through Geo-Redundant Storage from the to a paired region within the geo-political region (North Europe to West Europe).
Azure backup will take image-based snapshots daily. There are three levels of backup consistency that are achievable, depending on the workload and its activity at the time the backup is taken.
Backup
Virtual Machines running MS SQL Server
will be configured to back up to
a local Recovery Services Vault.
Backup Policies
can be created to achieve the
following: Full database
backups every day or week
Transaction
log backups every 15 Minutes to 24
hours Retention period is
maximum of 9999 Years.
The Auto
Protect feature will be enabled to ensure that any new
databases that are
created subsequent
to backups being enabled will be
protected.
Using this backup mechanism will allow
for reporting on backup
status, and provide
a faster recovery method compared to the SQL Managed Backup
to Storage
Blob feature.
CONSTRAINTS
Backup for SQL VMs support SQL
Server 2012, 2014
and
2016.
Pre-2012 SQL Databases will be
backed up with the Azure BM Image based (non-SQL database
aware) backup described in
section 5.8.2.1.1
MS SQL Databases that are
configured with the simple recovery model cannot
backup the transaction
log and will have a 24-hour RPO
MS SQL Databases that require
a lower RPO than 24 hours
must be configured with Full or
Bulk-Logged recovery model.
Databases
with large number of
files
can't be protected. The maximum number
of files that is supported is
~1000.
Azure Backup supports
only Full and
Copy-only Full backup types
for Read-only databases
A single Recovery Services
Vault can back up to ~2000
SQL Server databases
in
a vault. Additional
vaults will be created should
this limit be reached.
Replication
No comments:
Post a Comment