May 2010
Intermediate to advanced
815 pages
21h 55m
English
book
SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
by Tom Carpenter
Content preview from SQL Server® 2008 Administration: Real World Skills for MCITP Certification and BeyondBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...