Create a database backup that is in the azure

1

I would like to back up a database that is in Azure. I tried to back up by Microsoft SQL Server Management Studio, but the backup option does not appear.

I tried to backup through the Azure portal but did not have the option.

    
asked by anonymous 16.07.2017 / 18:22

1 answer

0

PaaS Azure SQL Database backups are automatic. No additional configuration is required for this.

It is performed every 5 to 10 minutes. It generates full backups, differentials and transaction log .

These backups can be recovered as follows:

  • Restore a database to a point in time within the retention period. This will create a new database on the same server as the original database.
  • Restore a deleted database to the time it was deleted or at any time within the retention period. The deleted database can be restored only on the same server where the original database was created.
  • Restore a database to another geographic region. This allows you to recover from a geographic disaster when you can not access the server or the database. It creates a new database on any existing server in the world.
  • Restore a database from a specific backup stored in the Azure Recovery Services vault. This allows you to restore an old version of the database to comply with a compliance request or to run an older version of the application. See Long-Term Retention .
  • To perform a restore, see Restore a database of backups .

Learn more about backup Azure SQL Database .

    
17.07.2017 / 09:07