Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site


Restoring SYSDB

If SYSDB is lost, a backup copy of SYSDB must be restored to allow Mimer SQL to start again. No Mimer SQL-based application can be used before this is done.

If SYSDB is lost or corrupted, a backup copy should be copied to the same file location as the original SYSDB. The contents of SYSDB may then be brought completely up to date by restoring LOGDB information. This is done using the backup and restore functionality in the UTIL program.

Start the program and login as SYSADM, or another user with BACKUP privilege. A message is displayed saying that you have an old version of SYSDB that must be restored. Answer "Y" to the question "Restore SYSDB" to restore the copy of SYSDB. Since SYSDB always has the LOG option, this will restore SYSDB to the state it had before it was lost.

Example, assuming a backup of SYSDB has been copied to the original location:

 MIMER/DB fatal error -16159 in function CONNECT
          Old version of the databank SYSDB cannot be accessed without
          restoring the databank with the backup and restore utility
                      -- Restore databank --
 Restore SYSDB?[Y]: Y
 Databank SYSDB restored from log

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