Use this dialog box to control how the specified data is to be restored.
Note that restore options vary for single and multiple database restore jobs. The differences are noted below:
|
|
Backup of the current transaction log is required before running a file/file group restore job. Use the No Truncate option when backing up the log. |
Destination Server
Displays the name of the instance to which the selected data will be restored. To change the destination, click one from the list.
The list includes SQL Servers in the CommCell which have the SQL Server iDataAgent installed. Note the following:
Source Server
Displays the name of the source server or database, depending on whether an instance or database was selected for restore.
Database Name
Displays the name of the database to be restored.
File List
Displays either the database or the names of the file to restore per database.
Database State
Displays the current state of the database.
Restore Entire Database
Specifies whether the restore operation must restore the selected database beginning with the most recent full backup and applying differential and/or transaction log backups up to the selected restore time.
Restore Type
Specifies that the restore operation must recover the databases to an available online state. No data is actually written. All other options are disabled when this option is selected.
Specifies that the restore operation must restore single or multiple databases to the selected date and time.
Note the following when this option is selected:
If the selected point in time is before any database backup was performed, a time selection out of range message will be displayed.
Partial restores, known as "Piecemeal Restore" in SQL Server 2005, allow databases that contain multiple filegroups to be restored and recovered in stages. The process starts with a restore of the primary filegroup, then a restore or recovery of one or more secondary filegroups.
Allows restores of the latest backup data on one or more non system secured database in the SQL Server. You can use this feature to create a spare copy of the primary SQL server database (hot standby server) within the same domain, a different domain, or across a Wide Area Network (WAN).
Select this option to NOT restore the last full backup since the specified date and time, but to instead restore only the transaction log backups. This option can be useful if the latest full backup has already been restored by third-party software and thus a restore of the SQL iDataAgent full backup is not necessary. Note that in such a case, this option only needs to be selected if a SQL iDataAgent full backup exists which is later than the full backup currently restored on the client by a third-party software.
Restore Time
Specifies the restore time. When restoring an entire database as a set of File/File Groups, select a date and time to which you wish to restore the files.
Time Zone
Lists the time zones. To change the time zone, click one in the list.
Recovery Type
Specifies the type of recovery that must be performed. This is the state of the database after the restore.
Specifies that the database will be fully operational.
Specifies that the database will be offline.
Specifies that the database will be in the read-only state (transaction logs may be applied).
Displays the path in which the undo file is stored, when the Recovery Type is Stand By. Use the space to modify the default path.
Once the restore is complete, the SQL Server iDataAgent will use the data from the undo file and the transaction log to continue restoring the incomplete transactions. Hence, once the restore completes, the undo file will be re-written with any transactions that are incomplete at that point.
Restore Options
When this option is checked, data being restored is unconditionally written to the specified location and will overwrite the files of any database that is currently using the database name specified by you. This implements the T-SQL REPLACE command.
When the option is unchecked, restore prevents the accidental data files overwrite by failing the job.
Specifies whether the restore operation leaves database in the DBO_ONLY state where only the owner of the database can access the database.
Specifies to restore backups of replicated databases. A published database can be restored to a server other than the server where the database was created. This is relevant only to full backups and if the database database was part of a replication implementation. This option is available only when the Recovery type option is selected.
Decryption
Click to enter the pass-phrase that is currently assigned to the client for restore operations that are run immediately.
Advanced
Click to select additional restore options.
Pre/Post
Click to add Pre/Post processing commands to restore operations.
Start Suspended
Click to start this operation in a Suspended state.
Change Priority
Click to change the priority for the restore operation.
Save As Script
Click to open the Save As Script dialog, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be executed from the Command Line Interface using qoperation execute command.
When you save an operation as a script, each option in the dialog will have a corresponding xml parameter in the script file. When executing the script, you can modify the value for any of these XML parameters as per need.
To view the XML values for each of the options in the dialog, see the following:
