N
N
nubic2018-08-06 19:54:37
Database
nubic, 2018-08-06 19:54:37

Database file corrupted, who is responsible?

Hello everyone, there was such a situation, help me figure out who is right in this case?
Some users could not enter the program, the reason: the database file is corrupted
(database file appears corrupt. page 0 is of wrong type). The system administrator, whose work includes backup, database restore, refused to solve the problem, said that the programmer should do this, arguing that if the programmer cannot solve this problem, then he is not qualified enough. The servers themselves and access to them are located in the admin room, only the system administrator has access to them.

Answer the question

In order to leave comments, you need to log in

4 answer(s)
P
Papa, 2018-08-06
Stifflera @PapaStifflera

DBA

A
Artem, 2018-08-06
@devspec

A sysadmin is not a database administrator. His area of ​​responsibility includes a backup restaurant, nothing more. Is there a backup for the date? Surely there is. Then there are no questions to the system administrator.
If such a position as "database administrator" is not provided for in the staff list, then the programmer will have to fix it.

C
CityCat4, 2018-08-07
@CityCat4

- Nothing is said about the architecture of the database, because the process of restoring a database from a backup in some cases requires some knowledge in the field - for example, an InnoDB format database in MySQL cannot simply be restored with a file :) The admin must have a backup for the previous day, but it will most likely be backup of the entire system , that is, if there are other databases there, they will also be restored to the previous state.
- The administrator is not obliged to repair the damaged database - he may well lack the knowledge for this. He doesn’t even have to write an upload-download script, although it’s not bad to have a backup by uploading the contents.

R
Roman Mirilaczvili, 2018-08-06
@2ord

The system administrator must make sure that the OS works properly and that there are no unplanned power outages during the operation of the DBMS. If the DBMS runs under low memory conditions, it can potentially corrupt data.
Or, due to an unplanned power outage, the file system did not have time to make the necessary changes.
The system administrator must restore data from a backup, but is not obliged to restore a broken database. Such restoration is a labor-intensive process and a positive result is not guaranteed.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question