Re: Database Recovery?

Posted in 1998

Neil Truby — Thu, 3 Sep 1998 10:20:13 +0100 — source: Informix-list mailing list archive (1991-1998)

Rick Stephenson wrote in message <6sjurs$qm1$1@acs2.byu.edu>... >In reading about Online Dynamic Server, it states that the database will >rollforward to the last checkpoint when the server is brought to online from >offline if the server crashes. If I do a restore from the day before will >it read the logs and bring it up to the last checkpoint also? > It applies all user updates right up to the point at the end of the logs, then rolls back all imcomplete transactions. Thus each user's work will be at the state of his or her last completed transaction. Neil Truby Londis Holdings London, UK