Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Please see if below helps. Currently Azure doesn't support restoring using .bak
Restore option unavailable in SSMS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAE%3C/text%3E%3C/svg%3E)
Aaron Erickson
1
Reputation point
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:
Thanks you,
Aaron
Azure Virtual Machines
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KarishmaTiwari-MSFT 20,842 Reputation points Microsoft Employee Moderator2019-12-11T00:57:27.093+00:00 Can you please share the correct link, the current one goes to msdn forum for virtual machines.
Sign in to comment
2 answers
Sort by: Most helpful
-
Vaibhav Chaudhari 38,981 Reputation points Volunteer Moderator2019-12-17T19:19:15.81+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 30%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
theodorbrander 56 Reputation points2019-12-17T18:46:16.943+00:00 Dear Aaron,
Is the .bak file stored in Recovery Service Vault?
https://learn.microsoft.com/en-us/azure/backup/backup-sql-server-database-azure-vmsOr 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