>We have an application that stores data on a Novell server.
>The server was shutdown while the application was still
>running. Several new records were lost. (must have been
>in memory when shutdown occured ??) I know foxpro sent the
>records because a label is printed after the inserts take
>place.
>
>When the server came back up the application had a "not
>a table" error message on 2 tables. Used desalvage to fix but
>there were several records in each that were missing.
>
>
>Is it likely that the records had not been written and
>were in memory?
>
>Any ideas on how to prevent this from happening again?
>
>Thanks,
>Dave
- Use the FLUSH command. This will guarantee that the record buffer on the local machine is flushed to the server...it does not guarantee the server buffer is written
- On the server, turn off ALL write cache. This will force the server to physically write to the disk everytime.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer