Restore option unavailable in SSMS

Aaron Erickson 1 Reputation point
2019-12-05T21:16:11.097+00:00

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

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
    2019-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-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

    0 comments No comments

  2. Vaibhav Chaudhari 38,671 Reputation points
    2019-12-17T19:19:15.81+00:00

    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