Did you know… Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete

We have observed a number of cases where the installation of SP2 succeeds on Active Node while it may fail on the passive node while installing SP2 on the clustered instance of SQL server 2005. In order to find the cause of the failure on passive node we need to check Summary.txt log in the…

1

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…

2