June 2007
Intermediate to advanced
720 pages
20h 39m
English
Three of the top 10 questions that Microsoft’s technical support receives are related to the Extensible Storage Engine (ESE) and data recovery. This section discusses the role of transaction logs and describes how they are used in the recovery of your databases in the event of a catastrophe. It also covers why databases fail and looks at some of the common error messages that accompany a database failure. See Chapter 16 for a step-by-step description of how to restore a database.
The Extensible Storage Engine is a transaction logging system that ensures data integrity and consistency in the event of a system crash or media failure. The design of the ESE was guided by four criteria. ...