Use this dialog box to control how the specified data is to be restored.
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.
Server State
Displays the current state of the server.
Refresh
Click to update the current state of the server.
-
Sybase Create Devices
Specifies whether to create devices.
-
Rename Databases
Specifies whether to rename the databases.
Note: If the original databases are online, a duplicate database will be created and the original databases are still kept.
-
Step-by-step
Specifies to restore the single database selected from the Latest Data dialog box (accessed using Browse). This field is displayed only when one database is selected for restore.
Options
- Point in time
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:
- Restore Time
Provides a space for you to enter the date and time. Click the arrow to display a calendar.
- Time Zone
Lists the time zones. To change the time zone, select one from the list.
Recover Types
Specifies the type of restore job.
-
Recover
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.
-
No Recover
Specifies that the database will be offline for the recovery.
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.
For more information on restores performed from the command line, see Command Line Interface for Sybase iDataAgent.