ContributionsMost RecentMost LikesSolutionsScheduled weekly restore of production SQL database to development Hi 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 usingbpimagelist 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. Cheers Alex Solved