Tag Archives: always on technology

How to add and remove a database to an availability group in Always On

How to add and remove a database to an availability group in Always On Rule: Connect to the server instance that hosts the primary replica. Use the T-SQL statement as below After you add a database to an availability group, you … Continue reading

Rate this:

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

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