Data Corruption


Corrupted data are data values that do not meet expectations, having been changed from the original or the intended data.

  • can occur at many points during a process, with a variety of causes:
    • humans
    • server failures
    • bugs
    • bad actors (like malware and viruses)
    • etc.
  • the database itself can become corrupt
    • In certain failure scenarios, this might mean the whole system is down
  • In SQL, those with the right permissions can run queries or commands to check the database for damage
  • If a stored procedure fails and corrupts the database
    • DBAs will likely establish an alert to notify you if it happens again
  • The quicker we know a system is corrupted, the faster we can fix it
  • have a proper backup strategy