Log Reader Agent Fails with the Error “The Log Reader Agent failed to construct a replicated command from log sequence number (LSN)”

Recently we encountered a case where in the Log Reader Agent fails to run and the following error is reported in the Replication MonitorError messages:The process could not execute ‘sp_replcmds’ on ‘TXDAL01410’. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)Get help: http://help/MSSQL_REPL20011Execution of filter stored procedure 2048634987 failed. See the SQL Server errorlog for more information. (Source: MSSQLServer,…

7

Did you know… Merge Replication Fails with Error ‘Unable to synchronize the row because the row because the row was updated by a different process outside of replication.’

Recently we have encountered a case where Merge Agent was failing to apply a transaction at the subscriber with the following error   Error Message============== The change for the row with article nickname 2336003 (test), rowguidcol {D46DF7AF-38C5-4B74-B07D-CF46A4E3B7EB} could not be applied at the destination. Further information about the failure reason can be found in the…

2

SQL Server 2005 Setup Failing to Install on Cluster with Unexpected Failure while Performing the SCC checks

We have observed a number of cases where the installation of the SQL server 2005 instance on the cluster fails with the following unexpected Failure Error Message while performing SCC checks. ERROR MESSAGE: ==================== There is unexpected failure. MSGID 50000 In order to troubleshoot the issue we followed the following steps 1)       We checked the…

1

Did you know… Auditing using DDL Trigger in SQL Server 2005

In the daily life of an SQL server DBA, we get numerous questions regarding the auditing possibilities for the different actions being performed on the database by different users. So it always comes handy if we have some kind of code ready to start the auditing of those specific events which are required. Also sometimes…

2

DID YOU KNOW…. When we create a database using “Create Database <database-name>” Database properties are not inherited from Model Database.

When we create the database using the Management Studio GUI, the size of the new database is the same as the Model Database and also the properties of the new database such as MAXFILESIZE, FILEGROWTH is inherited from the model database.   However when we create a database using following TSQL command without specifying any…

1