CODEWITHSUNDEEP
sqlsql-serverssmsdatabase-restoressms-2014
Pratik Bhattacharya
Pratik Bhattacharya

Reputation: 3746

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.

Upvotes: 12

Views: 6050

Answers (1)

Steven Green
Steven Green

Reputation: 3507

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/

Upvotes: 9

Related Questions