I want to automate a weekly restore of the most recent full backup of a SQL production database, to a development instance.
The problem I'm having is finding the job ID of the most recent backup.
I've tried using bpimagelist
bpimagelist -pt MS-SQL-Server -hoursago 48 -client Server1.com -idonly -st FULL
but I can't differentiate between the databases that are backed up on that instanace. Does anyone kjnow how to do this, or does someone have a better way to automate the restore.
Solved! Go to Solution.