O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required