>So, despite your experiences, I'd still highly recommend disabling write-caching on ANY device except one designed for full fault tolerance.
>
>Jim
I briefly experimented turning off the write-cache on my hard disks, and the computer became quite slow - I noticed this most when doing a hybernate. Sort of strange that - one should think that for hybernating, all data has to be written to disk NOW not later! Anyway, I turned it on again for performance.
One option which can be considered is to turn of the write-cache on individual disks - i.e., the disks that host the VFP database or the SQL Server database.
And where does NTFS fit in the picture? It is supposed to have transactional support, i.e., "all or nothing" is saved - but I suspect this would be more for writing individual sectors, without having inconsistent information in the file system (MFT, directories) - whereas a database will probably have to have coherent information amongst several sectors.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)