none
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.

    Thanks,

    Guru

    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 https://docs.microsoft.com/en-us/openspecs/. 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:

    https://docs.microsoft.com/en-us/answers/products/sql-server

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open Specifications

    Friday, October 30, 2020 4:11 PM
    Moderator
  • https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore

    hope answer the question 

    if resolve please mark as answer and vote

    Saturday, October 31, 2020 7:45 PM