Script to restore fulls and diffs to new server

astreet

Do you have a script example which can restore a new database on different server which apply full, latest differential, and sequential log files?

Brian Donahue

Hello,

I had done an experiment with VBScript a few years ago for a DR plan that may help you. It's by no means perfect, but it's meant to do what you want, namely to get the latest full backup file and apply all of the logs afterwards. I don't think it does differentials, though.

http://www.red-gate.com/messageboard/vi ... r+recovery