How to automate restoring sqlbackup files from azure blob to sql server vm RRS feed

  • Question

  • Hi All,

    My requirement is to automate restore SQL backup files from Azure blob storage to SQL server 2016 VM".

    Note: Manually I am able to perform  restore sql database backup files from blob storage to sql server vm through SQL server management studio UI.

    Please let me know if any solution is available to automate this requirement. Thanks in advance.

    Tuesday, October 15, 2019 12:23 PM

All replies

  • Are you looking to move the backup files from Azure blob storage to a storage on the VM hosting the SQL Server 2016?

    If yes, you can use ADF and schedule the jobs to pick the files from source and place in the destination at regular intervals. 

    Wednesday, October 16, 2019 12:25 PM
  • Is there any update on the issue?

    If the suggested answer helped for your issue, do click on "Mark as Answer" and “Vote as Helpful” on the post that helps you, this can be beneficial to other community members.

    Friday, October 18, 2019 6:23 PM