Restore a
database backup and its transaction log.
Prerequisites
Decide 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 SAP ASE.
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
- Click the Name field of the database, then click the drop-down arrow and select
Restore.
- 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 drop-down 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. SAP Control Center displays restore messages from the server.