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

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

Did you know… You will receive “Cannot open the PST because it is in use.” error when you configure SQLMail to use an internet mail server by using Outlook 2003

It is not recommended that you use Outlook 2002 or Outlook 2003 together with SQL Mail and with Internet mail servers that use SMTP or POP3. More info on this is available at http://support.microsoft.com/?id=897349 . Below is a practical workaround if you really need this to work. Plan here is to make sure SQL Agent…

0

How to setup a SQL Server Replication between three servers in a typical scenario..

Three Servers (Top, middle and Bottom) Data will flow from Top to the Bottom Server. Top to Middle Server (one way Replication) and Middle to Last Server (two ways Replication).   =================================================                                                  —->Top Server—-> Middle Server         Last Server                                                  <—- ==================================================   In order to get this replication topology done, we can use…

1

Did you know… Because of Collation settings for the database in SQL Server, you may not be able to navigate through the Database objects in Enterprise Manager

At times, when you try to open the tables within a Database in SQL Server 2000 Enterprise Manager, you may see below error(s):   1. Error while trying to explore table from Enterprise Manager: —————————————————————————————————– “Error: 2775: Code page 850 is not supported by the operating system.”   2. Error while trying to open tables…

1