Is there a way to prevent data lost or data corruption?

We are requiring UPS and implementing Flush commands in our application, but there are instance the the Computer Freezes or Hangs in the middle of transactions which causes data lost or corruption. Is there a bullet proof solution for this problem. If we move the database from Visual Foxpro to SQL Server will this solve data lost and data corruption?