question

anilkumar-3187 avatar image
0 Votes"
anilkumar-3187 asked anilkumar-3187 edited

Questions on Azure SQL database backups

Hello,

Just checked and found South East Asia region support following redundancy options for Azure SQL databases :
- Locally-redundant backup storage (LRS)
- Zone-redundant backup storage (ZRS)
- Geo-redundant backup storage
Also read redundancy option selected for a database dictates the PITR and LTR backup storage.

My questions are:

  1. What is the default redundancy option for Azure SQL databases in regions such as East US as above mentioned options are not available during database creation?

  2. How can you find out which redundancy option was selected for a Azure SQL database from Azure portal?

  3. If Geo-redundant backup storage is selected for Azure SQL database, can you configure Geo replication to paired Azure region? If yes, are two copies of database maintained in paired region? ( Tested this - selected Geo while database creation and couldn't see anything under Geo-replication blade. It seems like PIRT and LTR backups would be copied in paired region. If I want whole database to be available in a region, I can configure Geo-replication for that database. Is this correct?

  4. Can you request your database to be backed up by Azure before some user initiated operations are initiated ? If my Azure Db is of 100 GB and for some reason I need to modify huge amount of data - I just want to backup this database before that. I know I can just note down the timing and proceed with PITR if my operation needs to be rolled back.

Appreciate your insightful response. Thank you.


69031-azure-db.png

68924-azure-db2.png


azure-sql-database
azure-db.png (51.2 KiB)
azure-db2.png (59.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answers:

1 - Geo-redundant backup storage

2 - Go to Configure blade for Azure database in question and you will see which redundancy option was selected. You can even change that.

3 - Yes, Geo-replication needs to be configured.

4 - No, not possible as of today Feb, 2021.


0 Votes 0 ·

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered anilkumar-3187 commented

@anilkumar-3187

The first 2 questions are answered with combination of documents of Backup Storage Redundancy and Storage Redundancy. Additionally Yes Geo Replication should be used for availability of Databases in paired regions.

Azure doesnt take adhoc requests for back up and you should be cautious as it takes some time before full back up is taken for your DB and you start seeing your DB's in PITR. Also check other ways you can copy the DB.

Hope this helps.

Regards
Navtej S


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you so much @NavtejSaini-MSFT for your valuable help - I got answers for all four questions!!

Stay blessed and happy....

0 Votes 0 ·