Question 103068 in Azure Question posted in
The official documentation to get you started can be found here.

Azure – How to achieve RPO of 15 minutes

We are migrating a transaction-related database on SQL Azure with the following specs.

Single Database, vCore, General Purpose, Provisioned, Standard-series
(Gen 5), Locally Redundant, 1 – 12 vCore Database(s) x 1 Month, RA-GRS
Backup Storage Redundancy, 200 GB Point-In-Time Restore, 2 x 800 GB
Long Term Retention

The said database currently is on SQL Server on-prem, where log shipping to a DR site, helps us to commit to an RPO of 15 minutes to business.

Locally Redundant SQL Azure with vCore at this price point commits a max RPO of 12 hours (I might be wrong here).

Can we do something like log shipping or log backups every 15 minutes to achieve the same on the current priced SKU?

Tags:

2

Answers


  1. 0

    You can sync or replicate the data changes on that database every 15 minutes to a local on-premises database or to another Azure SQL using a free tool named SQL Data Sync. The replication can be bi-directional or in one direction. The frequency at which the sync occurs could be in seconds, minutes, hours and days.

    Login or Signup to reply.
  2. 0

    Azure SQL Database takes

    "Transaction log backups approximately every 10 minutes."

    Automated backups in Azure SQL Database

    And with "RA-GRS Backup Storage Redundancy" those backups are replicated to a second region. So that should meet your 15min RPO without additional work.

    If you need a tighter RPO or RTO you can configure Active geo-replication, which will create a readable secondary you can use for disaster recovery.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search