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