An Azure backup service that provides built-in management at scale.
Hello @TBFG Azure Admin ,
Thanks for reaching out Microsoft Q&A and sharing the details.
- Your current protection what you actually have two complementary things running, and that's a good combination:
- Azure VM backup (Recovery Services vault) – nightly snapshots that create recovery points containing the OS disk + both 1 TB data disks together. These recovery points live in two tiers: a Snapshot tier (stored with the disks, used for fast "Instant Restore") and a Vault tier (copied into the vault for longer retention).
- SQL Server (in Azure VM) workload backup – Azure Backup uses the SQL native APIs (VDI) to take full, differential, and transaction-log backups of your databases directly, streaming them to the vault. This gives you point-in-time restore down to the second and an RPO as low as 15 minutes, independent of the VM-level snapshot.
So the "VM Recovery Points (includes the two disks)" your crash/app-consistent VM image, and the "SQL Protected Databases" screenshot is your granular, point-in-time SQL recovery path. They serve different purposes keep both.
- Is your 3-step recovery plan correct?
Your idea to create a new VM from the image → restore last snapshot → change IPs — is close, but it's not quite how Azure Backup actually works. You don't need to pre-build a VM and then "apply" a snapshot to it.
Azure Backup gives you the following restore options directly from a recovery point:
| Restore option | What it does | When to use it |
|---|---|---|
| Create new VM | Spins up a brand-new VM (with new name, RG, VNet) directly from the recovery point. Uses restored OS + data disks. Must be in the same region as the source. | Original VM is deleted/corrupt and you want the fastest path to a working VM. |
| Restore disk | Restores the disks + gives you an ARM template so you can customize the VM (size, extensions, etc.) before creation. | You want to change VM SKU/config, or attach disks to an existing VM. |
| Replace existing | Swaps the OS/data disks on the existing VM in place. Source VM must still exist. Supported only for unencrypted managed VMs. | Rollback after a bad patch/change while keeping the same VM identity. |
| Cross Region Restore (CRR) | Restores in the Azure paired secondary region (requires GRS + CRR enabled on the vault). | Full regional outage. |
So the correct DR flow after a total loss is really just:
- Go to the Recovery Services vault → Backup item → Restore VM → "Create new virtual machine" (or "Restore disks" if you want to customize).
- Restore the SQL databases separately from the SQL in Azure VM backup item to the newly restored VM, choosing the exact point in time (up to the second) you need.
- Update IP/DNS/bindings for your websites as needed.
- Answering your specific "unknowns"
- Operating System + installed programs? Yes.
The VM recovery point contains the OS disk, so Windows Server 2022, IIS, SQL binaries, drivers, roles, features, and any installed applications come back exactly as they were at the snapshot time.
- Will SQL Server operate as normal? Yes.
The SQL Server instance is on the OS disk and is restored with the VM. But the database files you should actually rely on come from the SQL workload backups restore those to bring the databases to your desired point-in-time (transaction-log-level granularity, not just the nightly snapshot).
- Does the new VM have both data disks? Yes.
A VM recovery point captures all disks attached at backup time, so both 1 TB data disks are restored and attached to the new VM automatically.
- Realistic RTO – is 2–3 hours achievable?
It's usually feasible, but it depends on:
- Restore tier: Snapshot-tier (Instant Restore) is much faster than Vault-tier because the data doesn't need to be copied out of the vault first.
- Disk size: 2 × 1 TB data disks + OS disk take real time to hydrate.
- Post-restore work: SQL DB restore, IP/DNS/binding changes, app validation.
If you need a guaranteed low RTO/RPO with a hot standby, that's where ASR comes in below.
- Where Azure Site Recovery (ASR) fits and how it's different:
Azure Backup and Azure Site Recovery solve different problems:
- Azure Backup = protects against data loss / corruption / accidental deletion / ransomware.
Recovery is a restore operation and takes time proportional to disk size.
- Azure Site Recovery = protects against major disaster / regional outage. It continuously replicates the VM (OS + data disks) to another region (or zone). During a disaster you failover and a new VM is created in the target location within minutes, using the latest processed recovery point for the lowest RPO. You can also run non-disruptive DR drills to test.
So to answer your question yes, when you enable ASR on the VM, it will replicate the VM and its disks to your chosen target region/zone, and on failover it creates a new VM with new disks (and you can pre-configure the target VNet/subnet/IP for it).
Recommendation: For a business-critical Windows 2022 + SQL workload, the ideal setup is both:
- Azure Backup (what you have) for operational recovery, SQL point-in-time, ransomware protection, long-term retention.
- Azure Site Recovery for regional/zone disaster recovery with minutes-level RTO.
- Suggested DRP procedure:
- Keep nightly VM backups + SQL log backups every 15 minutes in the Recovery Services vault (GRS enabled, Cross Region Restore turned on).
- Enable Azure Site Recovery to a secondary region/zone and run a test failover every quarter no impact on production.
- Document your runbook: (a) failover via ASR or (b) restore VM from vault + restore SQL DBs to the point-in-time you need.
- After failover/restore, update DNS/IP/website bindings as needed.
References:
- How to restore Azure VM data in Azure portal
- About the Azure Virtual Machine restore process (OLR/ALR, Snapshot vs. Vault tier)
- Backup and restore options for virtual machines in Azure (Backup vs. ASR)
- Back up SQL Server databases on Azure VMs
- Restore SQL Server databases on an Azure VM
Hope this clarifies.
Thanks,
Suchitra.