Restore option unavailable in SSMS

Aaron Erickson 1 Reputation point


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,

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,419 questions
{count} votes

2 answers

Sort by: Most helpful
  1. theodorbrander 51 Reputation points

    Dear Aaron,

    Is the .bak file stored in Recovery Service Vault?

    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.

    Best regards

    0 comments No comments

  2. Vaibhav Chaudhari 38,671 Reputation points

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

    Restoring SQL Server backup to Azure SQL Database

    0 comments No comments