Backup / Restore of Sybase (SAP ASE) at Database-Level
Creation Date: September 17, 2009
Revision Date: June 12, 2015
Product: DS‑Client (Linux)
Summary
This article covers various backup/restore issues for the Sybase backup sets.
See Also
Restore
You can restore any backed up Sybase database into any existing Sybase database. This will overwrite all data in the existing database.
Database size issues
When you create a new database specifically for restore purposes, you must allocate at least the same amount of space as was allocated in the original (source) database.
Database “loading” issues
• You cannot load a dump that was made on a different platform or with a different version of Sybase server.
• If the database you are loading includes tables that contain the Primary Keys for tables in other databases, you must load the dump into a database with the same name as the source database.
• It is recommended that for the duration of the database load, you put the database into single_user mode to prevent other users from making changes to the database.