Problem
How to restore SQL databases which were backed up with Backup Exec.
Solution
2. From the Backup and Restore window select the server from the list then select Restore from the top bar.
3. Select SQL Server Databases in the Restore Wizard
4. Select the SQl Instance the database resides on, then select the database to restore.
5. Select the database time or transacation log to restore the database to.
6. Select if the database will be restored to the original location or redirected.
Note: Redirecting restores of SQL can be performed with "Redirect the data to a different SQL server instance and/or database name".
You can redirect the following:
A database backup to a different server, database, or instance.
A different file and folder path.
Differential and log backups to wherever the associated database is restored.
A database from a 32-bit or 64-bit platform to any other platform.
7. Select how to the database is restored
8. Select the consistency check option to use for the restore
9. Select the recovery state for the databases
10. Select any additional options needed for the restore
11. Enter a name for the job and set the schedule for when the job will run
12. Review the Retore Summary, click Finish to start the restore.