V
V
Vitaly Pukhov2015-02-10 06:52:42
Database
Vitaly Pukhov, 2015-02-10 06:52:42

How "survivable" database?

There was one interesting idea, but there is one point that keeps me from trying to implement it, the question is how databases (sql) are survivable in conditions of database damage, for example, if you take a hundred other sectors in the middle of a database file or damage the disk (HDD) so that it will be poorly / slowly read in some places, what will happen to the database in this case? Will it completely fall apart with the loss of data, or will only part of the data be lost and can you somehow find out which part and try to restore / delete the damaged part?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
DevMan, 2015-02-10
@Neuroware

In addition to the database files themselves, the DBMS also keeps a transaction log, which (if not killed) is used during recovery.
Well, in general, backups / replication are used to solve such problems.

P
Puma Thailand, 2015-02-10
@opium

Poorly survivable in case of serious damage, almost always data loss,
if the data is important, then a non-integral copy usually has no value as such.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question