What are the challenges you face when working across database platforms? Take the survey

How to schedule a daily restore of incremental files

Hello everyone. I am very new to sql scripting so please forgive my ignorance. The organization gets access to data from a vendor via FTP. They recommended we use RedGate to build and restore the database. The restore process has been done manually and I am looking for help on how to automate the restore process using the RedGate tool.

- Files are moved from the FTP site using WS-FTP Professional script and Windows Scheduler EVERY HOUR. 
- The production database is in standby mode and each file must be restored in sequence.

Thanks in Advance for the advice, resources, etc. 
Sign In or Register to comment.