recurring backup and recovery job
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.