locked
Refresh UAT Azure Data Warehouse With Production bacukp RRS feed

  • Question

  • Hello,

    I have been asked to refresh my UAT Azure Data warehouse using last backup from my Production Azure Data Warehouse. Both databases are in different subscription, Prod and UAT respectively. Can someone help on how this can be achieve using either azure portal or PowerShell?

    Any reply is really appreciated.

    Monday, January 28, 2019 4:57 PM

All replies

  • Hi,

    You can follow the steps given in below documents to restore the Azure Data Warehouse.

    Restore using PowerShell

    Another document for reference to backup and restore:

    https://docs.microsoft.com/en-us/azure/sql-data-warehouse/backup-and-restore

    Hope it helps.

    • Proposed as answer by angoyal-msft Tuesday, January 29, 2019 9:42 AM
    Tuesday, January 29, 2019 9:42 AM
  • Hi,

    Currently the only way to do this cross subscriptions (that I know of) is to:

    1) Create a new server in the production subscription

    2) Restore a copy of the DW to this new server

    3) Move the server to the Dev Subscription

    4) Restore from this new server in the dev subscription to the old server in the dev subscription

    • Proposed as answer by angoyal-msft Monday, February 4, 2019 4:59 AM
    Wednesday, January 30, 2019 12:30 PM
  • Hi,

    Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same. And, if you have any further query do let us know. 

    Monday, February 4, 2019 6:19 AM
  • Hi Kembiet,

    • Go to portal, access UAT SQL server 
    • Click on new restore point
    • Go to production SQL DW
    • Click Restore
    • Select user Defined restore point
    • And Select OK

    Should be able to restore, but it would have timestamp associated with your restore point and you need to rename it,

    ALTER DATABASE MyTestDatabase MODIFY NAME = MyTestDatabaseCopy ; GO

    Regards,

    Navin


    Navin.D http://dnavin.wordpress.com

    Thursday, February 14, 2019 9:05 PM