| |

SQL Server AlwaysON Group Failover in Cluster causes Node to lose network connectivity

Last week, I worked on an issue which might sound weird or strange when you hear it for the first time. “Whenever we fail SQL Server AlwaysON Group from Cluster, Node A loses its network connectivity.” (Sounds weird, Right ???) Here is the email which I received from my customer We’re able to re-create the…

Steps to Failover and Failback a Log Shipping Database in SQL 2000

Recently for one of our customers we had to perform a DR drill activity. To give a background on the environment, they were using SQL 2000 Database as a backend of SAP Application and the SQL Database was log shipped to Remote DR server. We had also customized the Log Shipping to add compression/decompression logic…