Search code examples
sqlsql-serverssmsdatabase-restoressms-2014

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.


Solution

  • 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/