Automatic restore last backup

[miasik]

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]

There is no way to do this automatically either via the GUI or BEMCMD.  You would have to do it define your job manually.

One other way is to create a separate copy of the SQL backup.  See this article

https://www-secure.symantec.com/connect/articles/simultaneous-sql-databases-backups-alternate-locati...

You then use SQL Studio to restore this copy of the SQL backup.