Link to home
Start Free TrialLog in
Avatar of atsci
atsci

asked on

Cold Backup of Visual FoxPro 7

I am quite unfamiliar with FoxPro and I am just looking to create a simple nightly cold backup. I can do this with SQL Server and Oracle but shutting down the database, then copying the datafiles. I am not sure how to do this in FoxPro.

Every backup article I find online is related to a hot backup. While a hot backup would be ideal, it seems there are no clean cut solutions without a 3rd party utility. A cold backup would be fine as it's not a database that needs to be online constantly.

ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Create a Dos batch file mention the following dos command in batch file
copy <your data directory\*.*> your backup directory name

Call the batch file either using any app. or win' scheduler. Be sure during the period your fox app./dbf should not be used by any user other wise it will give error.

Regards,
Bm Keshav