>Hi all ,
>Have u guys experience the problem about backup/restore the database ?
>In case of my program will change to resell version ,I wanna let the user can config the path of the backup directory .
>Now I only use stupid "copy c:\project\*.d* e:" .
>And it's cannot config by user .
>And the filename may change to abcdef~1.abc .
>Beside of using API ,any idea ?
>regards ,
>JK
I would suggest you open the backup directory table and append the data from current.
This can avoid the filename, both already exist.
and you can also backup even the file is in use by other user.
For example,
use backThu\myTable IN 0 ALIAS BkMyTable EXCL
SELECT BkMyTable
ZAP
APPEND FROM MyTable
USE in BkMyTable
Although The backup time would be longer, it would ensure the data is copied.
There maybe some unexpected error such as original data file corrupted.
COPY FILE will fail but append data from it works.
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.