"Backup" does not appear in SQL Server Management Studio 2016 or 17

Question

I am trying to back up the entire SQL Server database, so I can restore it if I mess up something (to update the entire Umbraco website). However, according to the Microsoft guide (and other users), the Backup task should be set. However, no.

This is for SSMS 17 (version 14). SSMS 2016 (version 13) shows the same thing.

Answer 1

To back up the Azure SQL Database, you need to select the Export Data Layer ... option.

This will create a .bacpac file, which can then be restored to another Azure SQL database or local SQL Server.

See Microsoft Documentation here for more details.

Answer 2

In Azure SQL DB, backups are automatic. If you want to export the database, you can export it to BACPAC (make sure that active transactions do not occur during export). See https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups and https://docs.microsoft.com/en-us/azure/sql-database/ sql-database-export .