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… Continue reading SQL Server AlwaysON Group Failover in Cluster causes Node to lose network connectivity

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… Continue reading Steps to Failover and Failback a Log Shipping Database in SQL 2000

Log Reader Agent Fails when the Sql server instance is failed over to Node 2

  We have observed a number of case where we use sql server replication on a clustered instance of sql server and when we try to failover from Node 1 to Node 2 the Log Reader agent may fail to start with the following error   Error messages: The process could not execute ‘sp_MSpub_adjust_identity’ on… Continue reading Log Reader Agent Fails when the Sql server instance is failed over to Node 2