question

AaronErickson-8266 avatar image
0 Votes"
AaronErickson-8266 asked ·

Restore option unavailable in SSMS

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
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Can you please share the correct link, the current one goes to msdn forum for virtual machines.

0 Votes 0 · ·
theodorbrander avatar image
0 Votes"
theodorbrander answered ·

Dear Aaron,

Is the .bak file stored in Recovery Service Vault? https://docs.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://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql

Best regards Theodor

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered ·

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

Restoring SQL Server backup to Azure SQL Database

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.