10.1. Understand Recovery Concepts
The entire SQL Server transaction architecture is really designed around the concept of recoverability. As a database administrator, you must be able to guarantee that your data is preserved and recoverable. Since you can't effectively design a recovery architecture without understanding SQL Server recovery concepts, we will begin with a discussion of transaction architecture and how it affects recoverability. Then we can examine different recovery strategies and match them up to your data recovery needs.
10.1.1. Understand Transaction Architecture
Transaction logging is a fundamental feature of SQL Server. It can provide for recoverability from a media-affecting failure as well as be the mechanism that makes ...
Get SQL Server® 2008 Administration: Instant Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
