3. Azure Sql Server

Replication:

Use Active geo-replication to create readable secondary databases of individual databases on a logical server in the same or different data center (region). If for any reason your primary database fails, or simply needs to be taken offline, you can initiate failover to any of your secondary databases. When failover is activated to one of the secondary databases, all other secondaries are automatically linked to the new primary.

Following are the steps to enable Geo Replication:

  • Go to your resource group in azure portal
  • Click SQL server
  • Select your database
  • Click on Geo-Replication
  • Select replication in same region

Backup:

Following are the steps for Back up:

  • Go to your resource group in azure portal
  • Click SQL server
  • Click Manage backup
  • Select the DB
  • Click configure retention
  • Choose your retention policies.

Suggest edit
Last updated on January 10, 2019
Suggest Edit