Identifying the Different Types of Database Failure for SQL Server 2000
There are three major types of failure that you will have to be concerned about as a SQL Server DBA.- User error - This accounts for either an application or a user incorrectly modifying or destroying data within the database. In this case, the decision may be made to take the database back to a prior point in time. In the event that this occurs, the DBA must be perform a recovery and restore the database to the state it was in prior to the user error occurring.
- Media Failure - This occurs when one or more drives used by the database fail.
- Catastrophic event - A major event destroys the data center.
The DBA will be responsible for protecting the data from these events and restoring and recovering the databases if such an event occurs.