Scripting restore of most recent backup

RichardRay

I have an identical database on two servers. Database on the Server A is production, Server B is reporting. I copy the nightly backup on Server A To Server B and use that as the source for reporting and analysis. I want to script the restore on Server B to use the most recent backup file available. Seem to be able to do that through the GUI, but I don't know how to script it

Hints? Examples?

J_D

You can do this via the 'Schedule Restore Jobs'function in SQL Backup (I'm on Version 9.2) There's an option there to restore the latest full backup. I've not used it myself but it seems pretty intuitive. 

RichardRay

Thanks, but that s through the GUI, I’m hoping to script it.  Unless, does the GUI offer a way to save a script? I’ll look at that when I get to work...

Eddie D

Hi, the last step of Scheduled Restore Job wizard is the summary step.  You will find a scripts tab, where you can copy the syntax of the job.

Many Thanks
Eddie