Hello @Girish ,
Thank you for reaching out to the Microsoft Q&A platform. Happy to answer your question.
I understand you have configured both SQL and VM backup for azure VM. Azure VM backup will backup complete VM, incase of restore, you have the below options
- Complete VM restore
- File/folder Level restore.
- Restore Disks
VM Recovery options:
Note : From an Azure VM backup you cannot restore the SQL DB alone.
Recommendation: It is a good practice to configure a seperate SQL workload backup which SQL DB backup. This gives you the ability to restore the specific SQL DBs quickly in case of any issues. It additionally provides the following advantages specifically for SQL Server:
- Workload aware backups that support all backup types - full, differential, and log
- 15 minute RPO (recovery point objective) with frequent log backups
- Point-in-time recovery up to a second
- Individual database level backup and restore
SQL restore options:
References: https://learn.microsoft.com/en-us/azure/backup/about-azure-vm-restore
Hope this helps!
--please don't forget to upvote and accept as answer if the reply is helpful--