Data Access Enhancements for Higher Availability

Other areas that Yukon has made great strides in for higher availability is that of maximizing data access. In other words, Microsoft is directly attacking several operations that previously required the table or whole database to be offline. For several critical database operations (such as recovery operations, restores, indexing, and others), Microsoft has either made the data in the database available earlier in the execution of an operation or made the data in the database completely available simultaneously with the operation. The primary areas addressed are

  • Fast recovery— A new faster recovery option will directly improve availability of SQL Server databases. Administrators will be able ...

Get Microsoft® SQL Server High Availability now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.