Re: Creating a copy of a database -- best practice?

Why not make a compressed file of the entire folder where the data lies? After file is created move it to a different machine off the network.

On Thu, Feb 28, 2019 at 4:17 AM Alan Bourke alanpbourke@fastmail.fm wrote:

Copy and rename all the data and database container files.

For each DBF in the copied and renamed data, update the backlink so that it points at your copied and renamed DBC. Open the copied and renamed DBC as a table, and update the metadata describing the tables to reflect their new names.

This is discussed here:

http://www.ml-consult.co.uk/foxst-47.htm

-- Alan Bourke alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]