Use this dialog box to make modifications in the names and locations of databases for restore.
Restore to this SQL Server
Displays the name of the server to which the database files listed will be restored.
Restore from Copy Precedence
When selected, the system retrieves the data from the storage policy copy with the specified copy precedence number. If data does not exist in the specified copy, the operation fails even if the data exists in another copy of the same storage policy.
When cleared, (or by default) the system retrieves data from the storage policy copy with the lowest copy precedence. If the data was pruned from the primary copy, the system automatically retrieves the data from the other copies of the storage policy starting with the copy with the lowest copy precedence and proceeding through the copies with higher copy precedence. Once the data is found, it is retrieved, and no further copies are checked.
Change
Click to select the copy, MediaAgent and/or Drive Pool used for the restore operation.
Edit the table to change database name of file path
Displays the list of database, database path and other information associated with the databases selected for restore. If necessary you can modify the database name and path from this list.
Database
Displays the name of the database. You can edit the name by clicking within the box. Changes cause the data to be restored to a new database on the selected server.
For a detailed description on how to change the name of the database, see the procedure titled "Restore a Database with a Different Name" in Books Online.
Logical Path
Displays the logical name of the database file.
Database File Path
Displays the complete path to the selected database file. You can edit the path by clicking within the box. Changes cause the database files to be restored to a new location. If the specified path does not exist, it will be created during the restore process.
Note, that if the database file path is changed, without changing the name of the database, then the existing database will be overwritten and will point to the new location. For a detailed description, see the procedure titled "Restore with a Different Data File Path" in Books Online.
Size (MB)
Displays the size of the database file in megabytes.
Max (MB)
Displays the maximum size of the database file in megabytes.
Find & Replace
Click to change multiple Database Name or Database File Path.
Reset
Click to resets all fields to their original values. Note that this button gets activated only if you have made changes to the original values.