Automated restore of SQL Server dbs on Azure VM from Backup RRS feed

  • Question

  • I have set up my database on SQL Server VM to backup to a Recovery Services vault. How can I schedule an automated restore to another VM ?
    Wednesday, April 29, 2020 7:46 AM

All replies

  • This is currently not supported. Recommend you to add a vote and comment on this feedback item to put up your voice to the product group to consider this feature request for future release. 

    ------------------------------------------------------------------------------------------------------------------------ If this answer was helpful, click “Mark as Answer” and Up-Vote. Feel free to reach out to us if you've any further questions in this matter.

    Wednesday, April 29, 2020 9:30 AM
  • Thanks for the response Sadiq.

    If that's the case how can I set up Log shipping when backup to a Recovery Services vault is enabled? As it says, "if you back up the transaction logs of this database with any other job or maintenance plan, Management Studio will not be able to restore the backups on secondary server instances" ?

    • Edited by Theroyale Monday, May 4, 2020 10:09 AM
    Monday, May 4, 2020 10:09 AM