Download INFORMIX-Enterprise Command Center User Guide

Restoring Data
If you want to restore the database server to a specific point in time, and you
have deleted any database spaces that existed at that point in time, be sure to
re-create the chunks of disk space originally allocated for those deleted
spaces before you perform the restore. For more information, see “Deleting
Database Spaces” on page 5-11.
To restore selected dbspaces or blobspaces
1.
If you are not connected to the server, right-click the database server
that contains the space or spaces you want to restore and select
Connect or Connect As.
For information on connecting to a database server, see “Connecting
to and Disconnecting from Database Servers” on page 1-16.
2.
Double-click the database server.
The Spaces folder appears.
3.
Double-click the Spaces folder to display database spaces.
4.
Select the database spaces you want to restore, right-click the
selection, and select Task➞Restore from the popup menu.
The BAR wizard appears.
5.
6.
Select a restore option:
■
Click Latest to restore the space to its state at the time of the last
transaction.
■
Click Specific Date and Time to restore the space to its state at a
specific date and time and specify values in the Date and Time
boxes.
Click Finish to accept the restore options and begin the restore
process.
If the server has other active or pending backup and restore activities, you are prompted to confirm if you want to queue the restore.
Click Yes to queue the restore.
7.
Follow the wizard’s instructions until it shows that the restore is
complete.
Warning: Data can be corrupted if you click Cancel during a restore.
If the restore fails, a failure event appears in the Events folder for the
database server. For instructions on how to manage events, see “Working
with Events” on page 4-10.
Data and Storage Management 5-29