Backup and Recovery

Making regular backups of your databases is crucial to the integrity of your database system. Although SAP ASE automatically recovers from system crashes (for example, power outages) or server failures, only you can recover from data loss caused by media failure.

• Keep Up-To-Date Backups of the master Database
  Backing up the master database is the most crucial element of any backup and recovery plan.
• Automating Backup Procedures
  Automate your backup procedure using an operating system script or a utility (for example, the UNIX cron utility) to perform the necessary backup commands.
• Verify Data Consistency Before Backing Up a Database
  Your database backups must be consistent and accurate, especially for master. If you back up a database that contains internal errors, the errors persist in a restored version of the database.
• Monitor the Log Size
  When the transaction log becomes nearly full, it may be impossible to use standard procedures to dump transactions and reclaim space.