Category Archives: Clustering

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

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

Rate this:

Posted in Clustering, Database Administration | 2 Comments