 |
|
|
 | Database Security Measures |  | 602SQL Server Administration | Damaged Database Restoration Methods |  |
You have to keep in mind that following events may occur when running a database:
Each of these situations has a different nature and causes different damage type.
Power supply failure or technical computer crash are situations which are most dangerous, if they occur amidst an actualization consisting of multiple actions. If the actualization is only partly complete, the database may get into a inconsistent state. As a result of this failure, unrecoverable sector damage may occur on some drives during writing data. Then this kind of event can be described as the following one.
Data written to a drive may be unreadable due to medium surface damage. In such a case it's very significant that the fact that data are unreadable may be detected when writing data or while reading them. In the first case the corrections are made much easier.
The access privileges system ensures that unauthorized users can't manipulate data. However this system can't prevent authorized user to accidentally damage important data.
It will be described further in this section how to prevent these events and how to protect the database from such events.
List of topics:
| Database Security Measures | | 602SQL Server Administration | Damaged Database Restoration Methods | |