Category Archives: Clustering
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
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
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
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
SQL Server Clustering from Command Line
Introduction In this tutorial I will show you few command line options to manage a SQL Cluster status as well as for falling over. Need of Command Line The graphical tool works great, but what can you do when your … Continue reading
Andrew Jackson
Mirza Husain
Mirza Husain 
You must be logged in to post a comment.