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

recurring backup and recovery job

Created: 21 Apr 2014 | 4 comments
David L's picture
1 Agree
0 Disagree
+1 1 Vote
Login to vote

Hi,

We have a requirment to use BE to backup the SQL2012 server as do many others. What feature we would like to add is to be able to backup specific databases and then start a targeted restore of the same databases.

Why?  The goal is to do a QA/Dev database refresh every weeknight. We want to take the backup of the production databases every night and restore them to the QA SQL server. This way the development team in India has access to the most current data.

This same concept could be used to replace RoboCopy. Currently RoboCopy copies data from the main servers to the DR site servers. This data includes SQL backup and other data.  

A same type of job as above "to backup that targeted data and recover the data to a remote server and/or file share" every night.

Accomplishes 2 things, tape archive and short term live copy.

 

 

Comments 4 CommentsJump to latest comment

CraigV's picture

Voted this up, but I've seen comments around this in the past. It was along the lines of it not being on any roadmap as the danger exists that an unwanted restore could be done, rendering the current data irrelevant.

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

0
Login to vote
David L's picture

Agree with the possable unwanted recover, but like any automated system there is a risk and being fully informed helps to midigate that risk.  However the goal here is a data refresh of the QA enviornment, and if it gets trashed, not a big deal, just restore and reload the manual way. I would not recommend this for production but in the event of a DR, this may be of value (a lot of assumptions here) if the backup is bad, the QA load may be the most current? Stranger things have happened, like the prod SQL backup failed because BE2012 took the drive off line....

 

Anyway thanks for the post!

0
Login to vote
CraigV's picture

I actually don't have an issue with an automated restore. But I do think some checks and balances would be put in place to alert you to the fact you've set up an automated restore, and maybe to ONLY allow a redirected restore.

Good idea either way!

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

0
Login to vote
pkh's picture

To do what you are trying to accomplish, you should use the SQL copy feature to get a copy of the database during the backup.

BE 2012 - copies of SQL DB.png

You can then use SQL Studio to restore these copies to the Dev/QA databases.

This feature is meant for situation like yours.

0
Login to vote