DescriptionĪlwaysOn can be configured at both the database level and instance level. It provides automatic recovery from failures, increasing the availability of critical applications and potentially reducing the risk for data loss, while avoiding downtime. In these situations, the primary objective of the system administrator is to bring back the system online as soon as possible with minimal data loss.ĪlwaysOn is a feature in SQL Server 20 that provides flexible and cost-efficient high availability and disaster recovery. System outages are either anticipated (planned) or a result of failures (unplanned) which may lead to data loss and impact the end user application experience. SQL 2012 Enterprise Edition introduced new features for configuring HA (high availability) on Microsoft SQL Server databases.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |