End Google Tag Manager (noscript) -->
USA +1 866 806 2068 | UK +44 203 1292 513 | JAPAN +81 3 45208991 担当:萩原 info@openlm.com

Backing Up the OpenLM DB – AN3101d

Introduction

OpenLM Server uses Firebird Embedded Server by default. By purchasing the External DB support extension, the user is licensed to use external DB such as Oracle, MS SQL Server, MySQL or Firebird Server.

This document describes a backup procedure to OpenLM Server. The suggested backup procedure must be tuned in order to accommodate different computing environments.

Cold Versus Hot Backup

This article only describes a procedure for cold backup. This method requires the system to be halted in order to assure a consistent backup file.

Hot backup is recommended for critical systems and requires the support of a professional DBA. This configuration will not be discussed in this article.

Embedded DB

OpenLM uses an embedded Firebird DB by default. The database file is located by default in C:\Program Files\OpenLM\OpenLM Server\db\. The DB file name is OPENLM_DB.FDB (or OPENLM_DB.GDB in older versions).

External DB

OpenLM Server supports external databases such as Oracle, MS SQL Server, MySQL or Firebird Server. When using external DB, the backup is done using the DB tools, usually by a DBA.

Backup procedure

  • Stop OpenLM Service; the picture below shows a manual stop of the service.

h1

  • Backup the DB file (embedded) or the External DB.

  • Start the service.