Redirecting restores for SQL

You can redirect the following:

Single-job restores and multiple-job restores can both be used in redirected restore operations.

To redirect a restore

  1. Start a restore job.

    See Restoring from SQL database backups.

    See Restoring from SQL transaction logs up to a point in time .

    See Restoring from SQL 2000, SQL 2005 or SQL 2008 transaction logs up to a named transaction .

    See Restoring from SQL filegroup backups .

  2. After selecting options on the Restore Job Properties dialog box, on the Properties pane, under Destination, click Microsoft SQL Redirection.

  3. Select the appropriate options as follows, and then start the redirected restore job or select other restore options from the Properties pane:

    Redirect Microsoft SQL Server sets

    Select this checkbox to enable redirection of SQL backup sets.

    Server

    Check Server to redirect the restore to a different server. After you check the check box, type the target server name.

    You can redirect a full database backup to a different server or database.

    If the drive configuration changes after the database backup was created, you must select either of the following options:

    • Default drive for restoring database files

    • Restore all database files to the target instance's data location.

    See Setting restore options for SQL.

    Instance

    Check Instance to redirect this restore to a named instance. After checking the checkbox, type the instance name. If you are restoring to the default instance, leave the field empty.

    This option is not supported under SQL 7.0.

    Database

    Check Database to redirect the restore to a different database on the destination server. After you check the check box, type the destination database name.

    You can redirect a full database backup to a different server or database.

    If the drive configuration changes after the database backup was created, you must select either of the following options:

    • Default drive for restoring database files

    • Restore all database files to the target instance's data location.

    See Redirecting restores for SQL.

    If you restore a differential or log backup, and the associated database backup was restored to a different server, type the new database name.

    Use alternate drive

    Select this option to select a default drive to which SQL database files can be restored.

    When a SQL database is backed up, the physical file names (which include the directory path) of the files that make up the database are stored in the backup set by SQL. For example, for the logical file pubs, the physical file name is stored as E:\MSSQL7\DATA\pubs.mdf. If the database must later be restored, SQL uses these same physical file names to target the restore to. During a restore, Backup Exec automatically creates any necessary subdirectories that do not exist.

    However, if the drive where one or more of the database files previously resided no longer exists, Backup Exec moves those files to their original directory path, but on the default drive specified. Using the same example, if the default drive C is specified, then the file with the original directory path of E:\MSSQL7\DATA\pubs.mdf is restored to C:\MSSQL7\DATA\pubs.mdf.

    If no default drive is specified in this situation, the job will fail.

    Only when original drive does not exist

    Select this option to use the alternate drive selected in Use alternate drive when the drive from which the database was originally backed up does not exist.

    Even when original drive does exist

    Select this option to restore all database files to their original directory path on the alternate drive selected in Use alternate drive, even if the drive where they originally resided exists.

    Do not select this option when restoring filegroups. Filegroups must be restored to the same drive letter and path that they were backed up from.

    Use destination instance's default data directory

    Select this option to restore files to the default data and log directories of the destination instance. For example, if you are restoring a database to a different instance of SQL, you would select this option to move the database files to the correct location for the new instance.

    If this option is not selected, then the files are restored to the directory that the master database is in.

    Do not select this option when restoring filegroups. Filegroups must be restored to the same drive letter and path that they were backed up from.

    Use this path

    Select this option to restore the database to a specific location on disk. To use this option, enter a drive letter and its corresponding path. For example, C:\temp. You can also click the ellipsis button and browse to a disk location. All paths entered are maintained in the Use this path drop-down list, which can be used for future redirected database restore jobs.

    Server logon account

    To restore to a server, use a Backup Exec logon account that stores the credentials of a Windows user account. The Windows user account must have been granted the System Administrator role on the SQL instance. The default logon account is displayed. To use another logon account, click Change.

    See About using Backup Exec logon accounts for SQL resources.

    SQL logon account

    If you are using SQL Server Authentication, use a Backup Exec logon account that stores the credentials of the SQL user account. Apply the Backup Exec logon account for the Windows user account to the Windows server that SQL is installed on, and then apply the logon account for the SQL user account to the SQL instance.

    To use another logon account, click Change. To remove the SQL logon account displayed in this field, click Clear.

    See About using Backup Exec logon accounts for SQL resources.

    Retain replication information

    Check this checkbox to retain the default settings of the database during a redirected database restore job. By default, Backup Exec retains default database settings during database restore jobs, except when database restore jobs are redirected.

    Check selections

    Click this button to have Backup Exec verify your SQL database restore selections. If selection errors are found, Backup Exec notifies you of the error or errors and then attempts to correct them for you.

More Information

Restoring data by setting job properties

About restoring SQL databases and file groups