After the SAP ASE database has been successfully restored with NetVault Backup, bring each restored database online. By using the SAP ASE software on the target SAP ASE Server, you must bring each successfully restored database back online. For instructions on bringing a SAP ASE database online, see the SAP ASE documentation.
It is important to understand how Incremental and Differential Backups are performed to restore either of these types of backup properly. Therefore, Quest recommends that you review and before attempting a restore of either type. The following topics outline the steps required to restore from Incremental and Differential Backups successfully.
IMPORTANT: To prevent an error from occurring, take the database offline before performing an Incremental restore.
Restore from an Incremental Backup: Last Full plus all relevant Incremental Backups: Using this strategy to restore a database to a specific point, first restore the original Full Backup and then each individual Incremental Backup in the order that they were created, up to the applicable point. The following example shows what would be required to restore a database to its most recently backed-up state, after the original Full Backup and two subsequent Incremental Backups had been performed.