Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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.