Backup SQL VM, Cancel/Delete SQL VM resources and reservation

Question

I am in the process of archiving an SQL VM and I would like to take backup of that resource and download it outside of the environment. After the backup is completed I would like to delete the VM and all of its associated resources and reservations. Please advise the best method to do so.

Answer 1

Hello,

Welcome to Microsoft Q&A,

I would suggest you the Azure Backup, Please find the steps below,

1. Use Azure backup to take a backup of your SQL -
   1. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup-restore?view=azuresql#azbackup
   2. Pricing - https://azure.microsoft.com/en-us/pricing/details/backup/
2. Export backups to external storage (Optional)
3. Before deleting the VM, Make sure to back up any other files/services in the VM
4. Delete the VM and associated resources like Public IP, NIC, Disk, etc.,
5. Steps to restore and manage can be found in the below link
   1. https://learn.microsoft.com/en-us/azure/backup/restore-sql-database-azure-vm
   2. https://learn.microsoft.com/en-us/azure/backup/manage-monitor-sql-database-backup

Please Upvote and Accept this as an Answer if it helps!