Schedule a restore from last backup

[larry_henderson]

I have a job on server1 that backups a database each night at 9:00pm. It takes 3 hours to back up. I would like to have a scheduled job that starts 5 hours later that restores that backup to a different server (server2 ) each night.

I can do this by manually creating the restore job each time and tell it what backup to restore. But I really need to have the restore job automatically know to restore the last backup on its own.

Thanks in advance for your help in solving this

[Ken_Putnam]

If you wanted it done immediately following the Backup, you could probably use policies to do it similar to executing a Duplicate job after a backup finishes, but If you really need it to wait 5 hours, I'm not sure how to do it.

Unless you stick a PreJob in that calls a VB or script file that just sits for 5 hrs before exiting

[Deepali_Badave]

Hello,

Please update us on this issue.


NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to answered questions pool.