The INTEGRATE LOG FILE command is available starting with 4D 2004.3. The INTEGRATE LOG FILE command integrates the log file, whose name or pathname was passed in the pathName parameter, into the current database. Afterwards, the file that was integrated becomes the new current log file of the database. This command is meant to be used for setting up a backup system using a logical mirror.

The command only works with 4D Server. It can only be executed via the Execute on server command or in a stored procedure. Only log files that are not archived (extension .4DL) can be integrated using this command. No dialog box appears; but a progress bar is displayed on screen.

INTEGRATE LOG FILE (pathName)

In the pathName parameter, you can pass an absolute pathname or one that is relative to the database folder. If you pass an empty string in this parameter, a standard open file dialog box will be displayed to allow you to indicate the file to be integrated. If this dialog box is cancelled, no file will be integrated and the system variable OK is set to 0.