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