How to schedule a daily restore of incremental files
graceworks123
Posts: 1 New member
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.
- 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.
