Hi everyone,
We're planning to migrate SQL Server databases from existing Azure VMs to newly provisioned Azure VMs running SQL Server 2022.
The production environment must remain online during preparation, but a maintenance window can be arranged for the final migration.
We're currently evaluating two approaches:
SQL backup/restore (export/import): Back up the databases, transfer the backup files, and restore them on the new SQL Server.
Azure managed disk detach/attach: Detach the existing data disks from the source VM and attach them to the new VM, then attach the databases to SQL Server 2022.
We're also considering snapshots to avoid modifying the original production disks.
My questions:
Which approach would you recommend for this scenario, considering the data volume and downtime?
Is disk detach/attach a safe and practical option when migrating to SQL Server 2022?
Would creating managed disks from snapshots be safer than detaching the original disks?
What prerequisites or potential issues…