Backing Up Data 
If a hardware problem or other error occurs, you return your database to a consistent state (restore) using backups. To speed up the backup process, you can back up data to several data carriers in parallel.
Recommendation
Regularly back up the data from your database to data carriers.
Use parallel backups whenever possible.
Prerequisites
Recommendation
Check the database structures of your database before carrying out a complete data backup.
More information: Checking Database Structures
You are logged on to the database as the database system administrator or as a DBM operator with server authorization for performing backups.
More information: Glossary, Server Permission
You have created a backup template.
If you want to backup to several data carriers in parallel, you need a backup template for parallel backups.
More information: Defining Backup Templates
The database is in the ONLINE or ADMIN operational state.
If you are using a third-party backup tool, connect it.
More information: Installation Manual, Connecting Third-Party Backup Tools
Only on Microsoft Windows:
If you want to back up data to a data carrier on a remote computer, perform the steps described in Database Administration, Backing Up and Restoring Data with Remote Computers.
Note
You cannot start an incremental data backup during a complete data backup, and vice versa.
Procedure
In the context menu of the database, choose Backup...
Choose the backup type:
Complete Data Backup:
You back up the entire data area.
Incremental Data Backup:
You back up all data in the data area that has been changed since the last complete backup.
Select the backup template.
Start the backup.
The system shows the current status of the backup procedure in the status window.
On the Backup Results tab page, the system shows the data carriers that have been used up to now.
Result
In the Actions view, the system shows the backup steps performed so far.
More information: Actions (View)
Example
You performed a complete data backup with the following backup template:
Property |
Value |
|---|---|
Name of the backup template |
COM |
Backup type |
COMPLETE DATA |
Data carrier type |
FILE |
Data carrier (Device/File) |
DEMODB_COM If you do not enter an absolute path, then the database system uses the run directory of the database. Example: C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\ More information: Run directory |
Size of data carrier |
No restriction (blank or 0) |
Block size |
8 pages |
Overwritable |
Yes |
The system writes the backup to the following file:
C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\DEMODB_COM
More Information
Database Administration, Backing Up Data