Restore a
database backup and its transaction log.
Prerequisites
Decide whether you want to load the backup into a new database with the
for load option, or into a preexisting
database.
Task
You cannot load a database backup that was created on a different operating system, or with an earlier version of Adaptive Server.
Note:
When loading an archive database, the block size and compression level are set to the
system default value for each stripe.
- In the left pane of the Administration Console, expand .
- Select one of:
- User Databases
- System Databases
- Archive Databases
- In-Memory Databases
- Right-click the Name field of the database you want to
restore.
- Click the arrow and select Restore to
start the Restore Database wizard.
- In the wizard's Introduction screen, choose:
- Default – loads a database or its
transaction log from a single or multiple dump devices.
- Restore using
script – loads a database from an existing SQL script.
- Restore
point-in-time – loads a database from a specified time in the
database dump sequence.
- Generate load sequence
only – generates database load sequence SQL from a specified
time. You can save the load SQL for future use. The load sequence consists of a
batch of load SQL, such
as:
load database testdb from...
load transaction testdb from...
You
may restore the database directly from the saved SQL script, either using
Execute SQL or script functionality in ASEMAP or by
using ISQL.
- In the Type of Restore screen, choose to restore the entire database or only the
transaction log. This option is available only when you select the
Default restore option.
- By default, the Dump Device screen is initially empty. Click
Add to identify the dump devices or dump stripes you want
to load back into the database:
- Named dump device – select the device from the
menu.
- Explicit dump device – specify a local dump device as
either an absolute path name or relative path name. When dumping across the
network, specify an absolute path name.
You can specify the backup server as
your remote dump device when using a default server. This option is not
available when loading an archive database; use Named dump
device instead.
If you select a remote backup server,
select its server name from the dropdown list.
- (Optional) In the Options screen, if you specified a password for backup, you must
use the same password while restoring the database.
Select Bring the database online to bring the database
online after the restoration is complete. By default, this option is not
selected.
- (Optional) Click Summary to view your selected options.
- (Optional) Click
Preview to view the SQL statement you generated with
your settings. To save a copy of the SQL statement, click
Save.
- Click Finish to start the restore process. Sybase Control Center displays restore messages from the Adaptive Server.