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

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