You can set the following options when you restore SQL backup sets to a different server.
See Redirecting restores for SQL.
Table: Microsoft SQL Redirection options
Item |
Description |
---|---|
Redirect Microsoft SQL Server sets |
Lets you enable redirection of SQL backup sets. |
Server |
Redirects 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:
|
Redirects 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. | |
Database |
Redirects 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:
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 |
Specifies 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:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\test.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:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\test.mdf is restored to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\test.mdf. If no default drive is specified in this situation, the job will fail. |
Only when original drive does not exist |
Lets you 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 |
Restores 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 |
Restores 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 |
Restores 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 |
Displays a Backup Exec logon account that stores the credentials of a Windows user account when you restore to a server. 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 .See How to use Backup Exec logon accounts for SQL resources. |
SQL logon account |
Displays a Backup Exec logon account that stores the credentials of the SQL user account if you are using SQL Server Authentication. 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 . To remove the SQL logon account displayed in this field, click .See How to use Backup Exec logon accounts for SQL resources. |
Retain replication information |
Retains the default settings of the database during a redirected database restore job. By default, Backup Exec retains default database settings during database resto |
Check selections |
Lets 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. |