Automatic restore last backup

Question

backup exec 2010 r3
i have everyday task for backup my production ms sql database.
i have another db for testing.
how to set up sheduled task for restoring last backup of production db to test db?

pkh · Answer

There is no way to do this automatically either via the GUI or BEMCMD. &nbsp;You would have to do it define your job manually.
One other way is to create a separate copy of the SQL backup. &nbsp;See this article
https://www-secure.symantec.com/connect/articles/simultaneous-sql-databases-backups-alternate-location-disk-using-backup-exec
You then use SQL Studio to restore this copy of the SQL backup.

Forum Discussion

Automatic restore last backup

Related Content

Incremental tape accidentally overwritten: restoring incremental backups?

Report Restore

Automatic Reports

Automatic Inventory?

Veritas 7.4 cluster resources goes offline automatically