Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unable to find Restore Database Option in SSMS

I am trying to restore a .bak file in my SQL Server using SSMS.
However I am unable to find the Restore Database option in the menu bar, when I right-clicked on Database. enter image description here

What can be the possible reason for that? Do I need to change some SSMS settings.
I am using SQL Server Management Studio 2014.

like image 543
Pratik Bhattacharya Avatar asked Oct 03 '15 00:10

Pratik Bhattacharya


1 Answers

It's not possible to restore a .bak file to an Azure SQL Database. To migrate data to an Azure SQL Database, see this documentation: https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/

like image 195
Steven Green Avatar answered Oct 02 '22 21:10

Steven Green