Video Screencast Help

Backup Exec 2010 - Scheduled Job to restore most recent backup

Created: 16 Sep 2013 • Updated: 20 Sep 2013 | 5 comments
This issue has been solved. See solution.

I am trying to do a daily restore from one SQL Server to another and also from one SAN to another.

I already have both of these backed up using Backup Exec 2010.  Is it possible to schedule a job to restore the most recent backup instead of having to manually select the data to restore?

Operating Systems:

Comments 5 CommentsJump to latest comment

pkh's picture

No.  This is not possible.  To do this restore you need to create a job and specify the latest backup set.


What you can do is to specify in your job, that a copy of the backup be made.

BE 2010 - SQL copy.png

In this example, .bak files would be placed in the C:\Temp directory when the backup job is done.  You can then use SQL Studio to restore these .bak files to the other SQL instance.

Rahul Kumar1's picture


      We cannot schedule a restore job. You need to manually create a job which you want to restore.


pkh's picture

Why are you repeating what I have said earlier?

Colin Weaver's picture

Can't you just setup some form of SQL Log shipping and not use a backup product to make your SQL data exist on 2 different SQL servers?

pkh's picture

... provided he is not doing any incr/diff/log backups.