Redirecting a restore of the Archiving Option databases

You can redirect the restore of the Archiving Option databases to a new SQL Server.

Symantec recommends that you use one job to restore all of the backup sets for the Directory database. If necessary, you can use multiple jobs to restore all of the backup sets. If you use multiple jobs, ensure that you leave the Directory database ready to use before you run the Change Database Location task in Backup Exec Utility.

Note:

All Archiving Option databases must be on the same SQL Server. If you redirect the restore of one of the databases, you must restore all of the databases to the same location.

See About redirecting the restore of Archiving Option components.

To redirect a restore of the Archiving Option databases

  1. Create a restore job.

    See Restoring data by setting job properties.

  2. Select the appropriate full backup set and any related differential and incremental backup sets to restore the Directory database.

    See About selecting data to restore.

  3. Enter other information on the Restore Job Properties dialog box as appropriate.

    See Restoring data by setting job properties.

  4. In the Properties pane, under Settings, click Archive.

  5. Select Leave the database ready to use; additional transaction logs or differential backups cannot be restored.

  6. In the Properties pane, under Destination, click Archive Redirection.

  7. Click Redirect to a new Microsoft SQL Server.

  8. Type the path to the SQL Server to which you want to redirect the restore.

  9. Click Run Now, or schedule a time to run the redirected restore job.

    See Scheduling jobs.

  10. When the redirected restore job is complete, start the Backup Exec Utility.

    See Running the Backup Exec Utility for an Archiving Option component.

  11. In the Backup Exec Utility task pane, under Archiving Option Tasks, click Change Database Location.

  12. In Destination SQL server instance, type the name of the new SQL Server.

  13. Click OK.

  14. After the operation completes, exit the Backup Exec Utility.

  15. Create a restore job.

    See Restoring data by setting job properties.

  16. Select the appropriate full backup set and any related differential and incremental backup sets to restore the vault store databases and the fingerprint databases.

  17. Enter other information on Restore Job Properties as appropriate. Do not configure information on the Archive Redirection dialog box.

  18. Click Run Now, or schedule a time to run the redirected restore job.

More Information

Schedule options

Redirecting a restore of the Archiving Option databases