SQL Azure Backup Strategy

Traditional SQL Server backup doesn’t apply to SQL Azure. SQL Azure have the following backup features.

Copy – Make a copy of the database on the server.

Restore – Restore a database from a point in time. Up to 7 days. Look at the “Oldest restore point” value.

Export – Create a .bacpac backup file to Azure Storage.

Backup Strategy

Database -> Make a Copy of the Database -> Export Copy of Database to Azure Storage

Make a copy of the database and then export the copy of the database to Azure storage.

-- Execute on the master database
CREATE DATABASE [db01_20190222063400] AS COPY OF [db01];