I am trying to have a copy of a transactional database on another server restored once a day for reporting purposes. SQL Server is the instance.
Original database is a member of an Availability Group. We can't extend the Availability Group. Full backups are taken once a day using Ola Hallengren scripts. I've tried using Log Shipping from Primary but it breaks Ola's backup job, so we can't use it.
Backups are sent to a blob container which has subfolders reflecting Ola's directory structure.
How to download just the latest .bak file from the directory in the blob and restore it over existing database? That process should be running in a SQL job?
Thank you for your help!