Migrate SQL on-premise solutions lift & shift , Azure Backup support backup SQL or not.

Question

Hi Everyone.

I find document refer from microsoft .

The situation I have SQL Server on-premise i would to migrate VM include SQL Server on-premise to Azure concept lift and shift concept, Azure Backup support backup SQL Server on VM in Azure or not , The SQL Server migrate from VM On-premise not new provision .

Please let me know . Thank you.

Answer 1

You can migrate the on-Prem VM including your SQL database inside the VM to Azure VM as it is using the Azure Migrate tool. The target VM in Azure will be the complete replica of on-Prem VM including all the settings.

Azure backup supports backup of SQL on Azure Virtual Machine. Refer this https://learn.microsoft.com/en-us/azure/backup/tutorial-sql-backup

Answer 2

Hello @Abdulloh Etaeluengoh

Thank you for reaching out to the Microsoft Q&A platform. Happy to answer your question.

As suggested in the previous response, the right approach to migrate a VM to azure is to Azure Migrate Service.

If it is a VMware VM, you need you follow the approach mentioned here https://learn.microsoft.com/en-us/azure/migrate/tutorial-discover-vmware

If it is Hyper-V VM, follow https://learn.microsoft.com/en-us/azure/migrate/tutorial-discover-vmware

Azure Backup is not a suitable approach for VM migration. The SQL VM on-premises can be backed up using MABS, but these types of backups are point in time restore points and quite useful for the Migration purposes.

Azure Migrate does a point to point asynchronous replication of disks from on-premises VM and creates a VM out of the replicated disks in azure(under the select region) upon Migrating.

For details see,
https://learn.microsoft.com/en-us/azure/migrate/tutorial-discover-vmware
https://learn.microsoft.com/en-us/azure/migrate/server-migrate-overview

Hope this helps!

If you have any further questions at all, please let me know in the comments.

If the answer provided by has helped, please 'Accept as Answer' and Upvote using "Thumbs-up" so that it can improve discoverability for others in the community looking for help on the same topic.