Data Availability
SQL Server 2005 provides several completely new features that help minimize down time, allow greater and faster data access, and provide additional data protection. These new features include online restore, online index operations, database snapshot, fast recovery, mirrored backups, database mirroring, snapshot isolation, and read committed snapshot. The online index operations, snapshot isolation, and read committed snapshot features are all based on another new feature called row versioning, which is a method of storing a copy of a row of data in memory or tempdb so that the data can be read by one process at the same time that it is being modified by another process without causing blocking. These new features are described ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
