After server is restarted, the database and the backups are destroyed by the system crash. What ACID properties are broken in this situation?
1
vote
2
answers
301
views
Let's assume that two transactions execute on a database, both reading, and writing. At some time, the system crashes. After the server is restarted, the database and the backups were destroyed by the crash and the database does no longer exists. Which ACID properties would this break?
My first guess is that it breaks only Durability since we can assume that transactions did nothing to the database ensuring atomicity, the database is definitely consistent, and I am not sure about isolation, but I don't see how would this break isolation.
Asked by ujoeja
(11 rep)
Nov 24, 2021, 07:55 PM
Last activity: May 9, 2023, 12:33 PM
Last activity: May 9, 2023, 12:33 PM