• Recover Database

    From Rich Ford@21:1/5 to All on Tue Jan 25 06:01:50 2022
    Is it possible to save a checkpoint file in a backup directory then destroy
    the database, create the database and then use this checkpoint file to recover the database the state prior to the destroy?

    Rich

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roy Hann@21:1/5 to Rich Ford on Tue Jan 25 16:22:58 2022
    Rich Ford wrote:

    Is it possible to save a checkpoint file in a backup directory
    then destroy the database, create the database and then use this
    checkpoint file to recover the database the state prior to the
    destroy?

    Like everyone else has said, I would discourage that approach.
    The preferred tool for that situation is unloaddb.

    That said, your disaster recovery plan should include all the steps
    required to do just what you suggest. In the event of a total loss of
    the facility (fire, flood, carpet moths) you need to be able to
    reinstate your database on a new machine using the checkpoint.

    I get the impression you are new to the site. You should ask if
    anyone else there knows where the disaster plan is.

    If they don't, your next step is to become a hero by writing it.

    Roy

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)