1. Forum
  2. Usenet
  3. COMP.DATABASES.INGRES

  • rollforwarddb

    From Rich Ford@21:1/5 to All on Fri Apr 29 08:57:21 2022
    We are trying to restore database on 11.1 to a couple days back running the following:

    rollforwarddb db1 -e27-APR-2022:01:02:00

    This seems to succeed but the databases is not set to this timestamp.

    Are there other steps involved?

    Rich

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roy Hann@21:1/5 to Rich Ford on Sat Apr 30 09:21:19 2022
    Rich Ford wrote:

    We are trying to restore database on 11.1 to a couple days back running the following:

    rollforwarddb db1 -e27-APR-2022:01:02:00

    This seems to succeed but the databases is not set to this timestamp.

    Are there other steps involved?

    Was it journalled?

    Run infodb on it and look for "The Database is not Journaled".

    Roy

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