Restore option unavailable in SSMS

Question

Hello,

The 'Restore Database' option is not available when looking to upload a .bak file to SSMS in Azure's Virtual Machine for MS SQL Server.

Is there a work around to import or upload a .bak file to SSMS so we are able to link our applications to the SQL Server? The link below shows what is trying to be accomplished, but I am unable to get past step #1:

https://social.msdn.microsoft.com/Forums/en-US/home?forum=WAVirtualMachinesforWindows&filter=alltypes&brandIgnore=True&sort=relevancedesc&searchTerm=SQL+Server

Thanks you,
Aaron

Answer 1

Dear Aaron,

Is the .bak file stored in Recovery Service Vault?
https://learn.microsoft.com/en-us/azure/backup/backup-sql-server-database-azure-vms

Or is this a VM you've created where you want to upload a on-premise .bak file?
Maybe one of these options will help you in that case.

https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql

Best regards
Theodor

Answer 2

Please see if below helps. Currently Azure doesn't support restoring using .bak

Restoring SQL Server backup to Azure SQL Database