Back Up and Restore Data

SAP supports tape drives and hard disks for backing up and restoring databases.

The dump command backs up databases and transaction logs.

To back up your databases, use a tape drive or a hard disk, depending on which media you plan to use for the dump.
The load command restores databases and transaction logs.

To copy SAP-supplied databases, see the Installation Guide.

Note: Always use the SAP ASE dump database and load database commands, rather than the Windows backup and restore utilities, to back up and restore SAP ASE databases. Using the SAP ASE commands ensures database integrity.

For more information about backing up and restoring databases, see the System Administration Guide: Volume 2.

Backing Up Data with a Tape Drive
SAP software can back up and restore databases to tape drives that are compatible with Windows.
Backing Up Data Using a Hard Disk
SAP software can back up data to any existing directory on a mounted Windows volume.
Dumping Across a Network
Backup Server may issue an “Access denied” message when you try to dump to a device mounted from across a network.
Examples of Backing Up and Restoring User Databases
Use the dump and load commands for backup and recovery of SAP ASE database on Windows.
Backing Up and Restoring System Databases
You can back up system databases the same way you back up user databases. It is not necessary to back up the tempdb database, as it is re-created every time the server restarts.

Parent topic: Manage SAP ASE Databases