How to schedule a daily restore of incremental files using Redgate???
Sanjib
Posts: 2 New member
Hello everyone, The organization gets access to data from a vendor via FTP. We have purchased the RedGate license 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.
We are getting the logs file every hour on daily basis in the FTP server.
- Files are moved from the FTP site using Windows Scheduler EVERY HOUR into desktop folder and it is happening every hour.
- The production database is in standby mode.
Question is -->
How to automate the Log files restoration using Redgate tool, so that it will restore all the upcoming log files on daily basis with any manual intervention?
Any help will be highly appreciated.
We are getting the logs file every hour on daily basis in the FTP server.
- Files are moved from the FTP site using Windows Scheduler EVERY HOUR into desktop folder and it is happening every hour.
- The production database is in standby mode.
Question is -->
How to automate the Log files restoration using Redgate tool, so that it will restore all the upcoming log files on daily basis with any manual intervention?
Any help will be highly appreciated.
Tagged:
Answers
Have you taken a look at our documentation for SQL Scripts Manager? You can find that here: https://documentation.red-gate.com/ssm.
This might help you determine what you need to do to restore those logs.