Restoring a Database

Restore a database.

  • Load the most recent database dump

  • Load, in order, all transaction log dumps made since the last database dump

  • Issue online database to make the database available for public use

Each time you add or remove a cross-database constraint, or drop a table that contains a cross-database constraint, dump both of the affected databases.

Warning!   Loading earlier dumps of these databases can cause database corruption.

For more information on backup and recovery of SAP ASE databases, see the System Administration Guide. Alternatively, you can use the sybrestore utility to restore databases. See sybrestore in the Utility Guide.