Commands and System Procedures to Restore Databases

Commands and system procedures for restoring databases from backups.

Command or System Procedure

Action

create database for load

Create a database for the purpose of loading a dump.

load database

Restore a database from a dump.

load transaction

Apply recent transactions to a restored database.

online database

Make a database available for public use after a normal load sequence or after upgrading the database to the current version of SAP ASE.

load {database | transaction} with {headeronly | listonly}

Identify the dump files on a tape.

sp_volchanged

Respond to the Backup Server volume change messages.