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

Author: Tracy Pearson

Posted: 2019-02-28 at 16:33:14

You'll have trouble the same way if a user is saving the Word or Excel file.

Writing to tables locks a portion of the table, and sometimes all of the

table which can cause copy failures..

You've been out of the VFP for a couple of years and haven't worked with

DBFs for longer.

We'll forgive your older age and forgetfulness.

Tracy

-----Original Message-----

From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen

Russell

Sent: Thursday, February 28, 2019 5:29 PM

To: profoxtech@leafe.com

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

Would the table or index not be included? I get backups of word and excel

files if they are open.

On Thu, Feb 28, 2019 at 3:40 PM

<mbsoftwaresolutions@mbsoftwaresolutions.com>

wrote:

> On 2019-02-28 07:08, Stephen Russell wrote:

> > 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.

>

>

> Because I think open DBFs would present a problem with that approach???

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/000d01d4cfb5$9869ae80$c93d0b80$@powerchurch.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2019 Tracy Pearson