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.

  1. Extracting the zipped folder into a different folder in the local drive
  2. 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!


  • what have you done so far so we can help you if you are stuck ? to me this looks like you are just looking for a ready made solution without any effort. – Kin Shah Nov 15 '19 at 2:32

Keep in mind that the first time your client does full backup, you will not be able to restore log files before full backup restore, so that step should be implemented in your automation.

| improve this answer | |
  • This should be a comment rather than an answer. – Kin Shah Nov 15 '19 at 12:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.