"Back Up" not appearing in SQL Server Management Studio 2016 or 17
azure-sql-database, sql-server, ssms
Solution
To backup a SQL Azure database you need to select the "Export Data-tier Application..." option.
This will create a .bacpac file which you can then restore to either another SQL Azure database or an on-premises SQL Server.
See the Microsoft Documentation here for more details.
Problem
I am trying to backup my entire SQL Server database, so I can restore it in case I mess something up (about to revamp my entire Umbraco site). However, according to Microsoft's guide (and others' as well), there should be a task called Back Up. However, there is not. That is for SSMS 17 (version 14). SSMS 2016 (version 13) shows the exact same thing.