Switch branches/tags
Nothing to show
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
..
Failed to load latest commit information.
01.CreateDbs.sql
02.CreateAG.sql
03.AlterAG.EnableDBHealthLevelDetection.sql
04.VerifyAG.EnableDBHealthLevelDetection.sql
05.CorruptData.sql
06.AddCorruptDbToAG.sql
07.GenerateLogicalConsistencyError.sql
08.WriteToSuspectDbTransLog.sql
README.md

README.md

SQL 2016 Availability Groups DB Health Level Detection demo

This demo shows the benefits for using the Database Level Health Detection option of Availability Groups in SQL Server 2016.

To follow this demo refer to this Blog Post

Prerequisites

To use this demo you should deploy the sample SQL AlwaysOn environment from the Azure Market Place.

Alternatively you can use any AlwaysOn Availability Group environment with at least 2 Replicas that can be configured in Synchronous Commit Mode with Automatic Failover.

DO NOT PERFORM THIS DEMO ON ANY PRODUCTION ENVIRONMENT or DATA!

Disclaimer

The demos are provided “as-is”. The information, opinions and views expressed are those of the author and do not necessarily state or reflect those of any other company with affiliation to the products discussed. This includes any URLs or Tools. The author does not accept any responsibility from the use of the information or tools demonstrated within these demos, and recommends adequate evaluation against your own requirements to measure suitability.