Microsoft SQL Server Redirection tab field descriptions

Table: Restore options on the Microsoft SQL Server Redirection tab describes the restore options on the Microsoft SQL Server Redirection tab.

Table: Restore options on the Microsoft SQL Server Redirection tab

Item

Description

Redirect Microsoft SQL Server sets

Check this option to enable redirection of SQL backup sets.

  • SQL Logon Account User Name

    For SQL Server Authentication, enter the logon account that stores the credentials of the SQL user account. You do not need to provide a user name and password for integrated security. More information is available on standard and integrated security.

  • SQL Logon Account Password

    Indicate the password that is associated with logon account.

  • SQL Redirection

    To redirect this restore to a named instance, type the name of the server and the instance name, in the format "server_name instance_name". For example, aj civolus.

    If you have redirected the default instance, type the name of the server, in the format "server_name". For example, aj.

  • Restore to Database

    To redirect the restore to a different database on the target server, type the target database name; otherwise, leave the field blank.

    You can redirect a full database backup to a different server or database. However, if the drive configuration is different from when the database backup was created, you must make the following selections. Select either Alternate drive for restoring database files or select Restore all database files to the target instance's data location on the Microsoft SQL Server tab.

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

More Information

About SQL Server privileges

Microsoft SQL Server tab field descriptions