Home | Previous Page | Next Page   The Database Server > Overview of Database Server Administration > Routine Tasks >

Backing Up Data and Logical-Log Files

To ensure that you can recover your databases in the event of a failure, it is recommended that you make frequent backups of your storage spaces and logical logs.

How often you back up the storage spaces depends on how frequently the data is updated and how critical it is. A backup schedule might include a complete (level-0) backup once a week, incremental (level-1) backups daily, and level-2 backups hourly. You also need to perform a level-0 backup after performing administrative tasks such as adding a dbspace or logical log or enabling mirroring.

Back up each logical-log file as soon as it fills. You can back up these files manually or automatically.

For information on using ON-Bar, see the IBM Informix: Backup and Restore Guide.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]