Avaya Customer Interaction Express 1.0, User Manual

Page: 309 / 344

Database maintenance and repair
Edition: 1.1 03/08/2007 309
Database maintenance and repair
Backing up the database
You can back up data to a file or tape. Please note the relevant prerequisites.
You can make a backup while CIE is running.
What is a backup server?
The backup server is used for backups, dumps, restores and loads of certain databases and transaction
logs for Adaptive Server Enterprise.
A backup server must run in the same system as the respective installation of Adaptive Server Enterprise.
Guidelines for backing up the master database
Back up the master database after every change. Each process concerning hard disks, memory,
databases or segments leads to changes in the system tables of the master database. Back up the master
database after creating the CIE database and after increasing the size of the CIE database.
Guidelines for backing up the CIE database
Back up the CIE database after the following events:
• Right after installation to have a basic backup copy. Afterwards, back up the database according to
a schedule. The recommended minimum default is to back up the transaction log daily and the
database weekly.
• After deleting entries from the transaction log without creating a backup copy.
• Before each upgrade using the CIE setup.
Online help for Sybase
The Online Help for Sybase, which lets you search by error number, can be found at:
http://manuals.sybase.com/onlinebooks/group-as/@Generic__CollectionView;pt=group-asarc;lang=en