Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site


Backup and Restore

This chapter discusses backup and restore of Mimer SQL databanks. Two types of backup procedures are described:

Some of the discussion in this chapter refers to Shadowing, see Shadowing Functionality, which is an optional Mimer SQL facility that allows one or more copies of a databank to exist on different disks.

Shadowing provides a high level of protection from disk failure because the system will automatically use a databank shadow if the master databank is lost, thus allowing normal database activity to continue without interruption. Databank shadows also allow a copy of a databank to be temporarily set offline (e.g. to be backed up) without interrupting normal system use.

Several references to transaction handling are made in this chapter. If you are not familiar with transaction handling in Mimer SQL see chapter 6 of the Mimer SQL Programmer's Manual or chapter 6 of the Mimer SQL User's Manual for a more detailed description.

The backup and restore functionality in the UTIL program is still supported for backward compatibility, but is not recommended for production systems.

Background Information

A Mimer SQL database consists of a collection of databanks (each in a separate operating system file) containing tables with data used by the applications. The SYSDB system databank contains a data dictionary describing the different objects in the database.

Note: Backup protection for SYSDB is particularly important for protecting the database, since SYSDB contains all information describing the database structure. If SYSDB is lost, the system must be rebuilt from scratch.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
Mimer SQL System Management Handbook TOC PREV NEXT INDEX