I am wondering if I get help from this house on the following issue. I have a standby database that should be restored with the set of transaction log files I get from the vendor's(eClincalWorks) sftp site daily.
The automation I am looking for is to do the following tasks:
1- Download the daily transaction files from the vender's sftp site and save to the local drive. Note: the files in the sftp server are in a zip folder named as db_xxxx_today'sDate contains the daily transaction log files that are backed-up every 30 min at the production server.
- Extracting the zipped folder into a different folder in the local drive
- Scheduling restoration of the extracted-log files into the SQL database in the correct LSN order and in standby mode.
Please let me know if I need to explain more to my question and thanks in advance for any of your help on this matter!