SQL Server 2000 Types of Database Failure

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.

Looking for SQL 2005?

I am currently working on SQL Server 2005 Backup and Recovery Exercises and will have the first exercises posted by 10/31/2008. SQL Server 2005 Backup and Recovery exercises will include GUI examples, T-SQL examples, and I'll also be including Video tutorials so you can easily follow along with the backup and recovery exercises. SQL Server 2008 exercises will be posted towards the end of 2008.

Contact Me

Please contact me with any suggestions that you have for the web site. I'd also appreciate any feedback on how the exercises worked for you, and how the site helped you put together a comprehensive backup and recovery plan - or even helped to save your data after a disaster. Contact Me Here.