You are attempting to fix a problem that has nothing to do with code or database - you need better hardware, ups's, backups, and users trained correctly.


>Hi,
>Thank you for info.
>The problems here are,
>
>1. Some of my clients may use bad or may be low end hardware.
>2. Users shutdown server inproperly/accidently.
>3. No backup battery
>and etc
>
>So, all the above cause memo file curruption and data lost for whole day trasnaction. If SQL server can solve this problems, then only I plan to move. Otherwise, I can't get a good reason to ask for myteam to rewrite the program.