Create a database backup that is on Azure

Asked

Viewed 203 times

2

I’d like to back up a database on Azure. I tried to backup from Microsoft SQL Server Management Studio, but no backup option appears.

I tried to back up the Azure portal, but you don’t have the option.

sql-server windows-azure

  • Are you using Azure SQL Database? Or is it your VM with Sqlserver installed?

1 answer

1

The Paas Azure SQL Database backups are automated. No additional configuration is required for this.

It is held every 5 to 10 minutes. It generates backups complete, differentials and of transaction log.

These backups can be recovered as follows:

  • Restore a database to a point in time within the retention period. This operation 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 on which the original database was created.
  • Restore a database to another geographic region. This allows recovery of a geographic disaster when you are unable to 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 meet a compliance request or to run an old version of the application. Consult Long-term retention.
  • To perform a restore, see Restore a database from backups.

Learn more about Azure SQL Database backup.

Browser other questions tagged sql-server windows-azure

You are not signed in. Login or sign up in order to post.