Scripting restore of most recent backup

RichardRay · December 17, 2019 9:32PM

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 · December 18, 2019 10:14AM

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 · December 18, 2019 3:08PM

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 · December 19, 2019 9:54AM

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

Scripting restore of most recent backup

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk