Azure SQL Data Warehouse Geo-Backups & Auto Restore Backup files RRS feed

  • Question

  • Dear Experts,

    In Azure SQL Data Warehouse, By default geo-backup and auto backup is enabled with RPO as 24 hours for Geo-Backup and 8 Hrs for Restore Point. I have few doubts in that.

    1) Is Geo-Backup in paired data center should be used only in case of unavailable of primary region?

    2) How to get Geo-Backup File location in paired data center?

    3) Is Geo Backup & Auto Restore point backup file info is captured in sys.pdw_loader_backup_runs?

    Thanks for your valuable inputs.



    Friday, October 30, 2020 9:36 AM

All replies

  • Hello Guruprasath,

    This forum is dedicated to supporting issues related to open specification. You can access open specifications at Your inquiry does not seem to be related to open specifications.

    For a better chance of getting an answer to your question, you may want to post your question to the following forum:

    Sreekanth Nadendla
    Microsoft Windows Open Specifications

    Friday, October 30, 2020 4:11 PM

    hope answer the question 

    if resolve please mark as answer and vote

    Saturday, October 31, 2020 7:45 PM