Chapter Essentials
The Importance of Data Redundancy Data redundancy is essential to recoverability. If your data exists only in one place, it cannot be recovered should that storage location fail. Internal data redundancy is provided using hard disk RAID. RAID levels 1 and 5 provide redundancy. RAID level 0 does not. RAID level 0 only provides for performance improvements.
Using Database Mirroring Database mirroring should not be confused with RAID mirroring. RAID mirroring is a drive-level concept. Database mirroring is a transaction-level concept within a SQL Server architecture. When mirroring is enabled, the mirror database receives updates on a transaction-by-transaction basis. For this reason, database mirroring is considered a low-latency ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.
