While configuring SQL Server AlwaysON Availability Groups, as a part of security hardening practice it is recommended to configure Availability Group to listen on a non-default port other than 1433. However the moment you configure your Availability Group Listener on … Continue reading
Category Archives: AlwaysON
When do we need asymmetric storage with AlwaysON FCI and Availability Storage?
TweetBefore we start the discussion on SQL 2012 AlwaysON let me define the terminologies introduced with SQL 2012. As we all know with SQL 2012, we have AlwaysON solution which provides us with a HADR Solution. SQL 2012 AlwaysON can … Continue reading
SQL Server 2012 AlwaysON Automatic Failover Set – Caveat
TweetAs I was going through the documentation of AlwaysON, I came across the following caveat with SQL Server AlwaysON Automatic Failover set. While we can have upto synchronous secondary replica, we can have only one secondary replica to be part … Continue reading
Considerations for Configuring Log Shipping for a cross-domain clustered instance of SQL Server over a Firewall
TweetLast week, one of my customers had engaged me for consulting to configure Log Shipping on clustered instance of SQL Servers which are running in different domains. In other words, the primary and secondary servers are in different domains. While … Continue reading
Failed to join the instance to the availability group while configuring AlwaysON
TweetAs SQL 2012 is in it’s RC0 phase, I was trying to configure AlwaysON on my 2-node WSFC with node and disk majority.Next I installed Default instance of SQL Server in parallel ( to save some time ) on both … Continue reading