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:
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.
Source Server
Displays the name of the source server or database, depending on whether an instance or database was selected for restore.
Destination Server State
Displays the current state of the server.
Refresh
Click to update the current state of the server.
Options
Specifies the restore options. You may select any or a combination of both data and log restores along with different types of restore.
When selected, specifies that it will allow Data only restores. You will be able to get only database dump files of any FULL job.
When selected, specifies that it will allow Log only restores. You will be able to recover any logs from any backup job.
When selected, allows you to replicate data from one server to another to be used in Fail over cases.
Specifies that the restore operation must recover the database.
- Staging Location
Specifies the path of the Destination Folder to store the data and logs for Windows and logs only for Unix.
- Browse
Click to specify the path of the Destination Folder to store the data and logs.
Specifies that the database will not be recovered.
Point in time
- Destination Folder
Specifies the path of the Destination Folder to store the logs without applying to the server.
- Browse
Click to specify the path of the Destination Folder to store the logs.
Specifies that the restore operation must restore single or multiple databases to the selected date and time.
Restore Time and Time Zone
Displays only those jobs that occurred within the specified point in time. Select the following options:Provides a space for you to enter the date and time. Click the arrow to display a calendar.
Lists the time zones. To change the time zone, select one from the list.
Advanced
Click to select additional restore options.
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: