Tag Archives: sql server always on

Always On in SQL Server 2017 (Read-Scale Feature)

Always On in SQL Server 2017 (Read-Scale Feature) SQL server 2017 has introduced new feature and technology (read-scale availability group) with Always on. Now, Always On availability groups provide high availability, disaster recovery and read-scale balancing. Read-Scale Availability Group: This … Continue reading

Rate this:

Posted in always on, Clustering, Database Administration, T-SQL | Tagged , , , , , , , , , | Leave a comment

AlwaysOn Pre-Requisites

AlwaysOn Pre-Requisites  1.Windows 2.SQL Server 3. Databases Hotfix for .NET 3.5 SP1 adds support to SQL client for AlwaysOn. Windows Requirement: The system should not be in a domain controller Windows server 2012 or later versions should be running on … Continue reading

Rate this:

Posted in Clustering, Database Administration | Tagged , , , , , , , , , , , , , | Leave a comment

Always On – Interview Notes

Always On Always on Availability Groups is a solution which improves database availability and supports a failover environment for a discrete set of user databases. It is introduced in SQL server 2012. Benefits: With the release of Windows Server 2016, … Continue reading

Rate this:

Posted in Clustering, Database Administration | Tagged , , , , , , , , , , , | Leave a comment