Restoring a Database

Make certain the database you are attempting to restore was backed up using the proper method described above.

Note: Database names are case sensitive.

To restore the database

  1. Remove osc-dbid file from the Borland\CaliberServer\Versant\DB\ installation directory.
  2. Select Start > Programs > Command Prompt.
  3. At the command prompt enter dbmgr -stop to stop the database.

    To ensure the database is stopped after a dbmgr -stop command, the following four processes should not be present in Task Manager:

    • caliber_srv.exe,
    • cleanbe.exe
    • obe.exe
    • sqm_monitor.exe
  4. At the commend prompt, type dbid –N.
  5. At the command prompt,

    enter vbackup -dev [path & file name for backup file] - restore [db name]

    substituting [path & file name for backup file] for the correct path and filename for the backup file and [db name] for the name of the database you are restoring.

    Example: vbackup -dev C:\Caliber_Backup\SQMDB.bak -restore SQMDB

    • Answer
       no
      to prompt about applying logical log.
    • Answer
       no
      when prompted to restore another level of backup.
  6. At the command prompt, enter the command: stopdb [db name], substituting [db name] for the name of the database you are restoring.

    Example: stopdb SQMDB

  7. At the command prompt, enter the command: startdb [db name], substituting [db name] for the name of the database you are restoring.

    Example: startdb SQMDB

  8. At the command prompt, enter dbmgr -start to start the server.
CAUTION:
When moving a Versant database from Machine A to Machine B, you should use the backup and restore processes.
Note: When performing and upgrade, the installer moves the existing database to the directory “C:\Borland\CaliberServer\Versant\DB\DB_Backup”. When performing the restore operation, you will have two copies of the database on your disk.