Back Up and Restore Data

Sybase 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 Sybase-supplied databases, see the Installation Guide.

Note: Always use the Adaptive Server dump database and load database commands, rather than the Windows backup and restore utilities, to back up and restore Adaptive Server databases. Using the Adaptive Server 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
Sybase software can back up and restore databases to tape drives that are compatible with Windows.
Backing Up Data Using a Hard Disk
Sybase 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 Adaptive Server 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 Adaptive Server Databases