Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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.

*EDIT*

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.

SOLUTION
Rahul Kumar1's picture

Hi,

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

Thanks

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.