High Availability for SQL Server Replication using Database Mirroring

Here we will Discuss on Providing High Availability for SQL Server Transactional Replictaion using Database Mirroring : Highlights of this video blog :- 1. Transactional Replication Overview. 2. Database Mirroring Overview 3. Replication with Database Mirroring. 4. Mirroring the Publication database 5. Effect of the Mirroring state on the Replication Log Reader agent. 6. Mirroring…

3

SQL Server Replication

Queries on SQL Server Replication? Check out our blog to get’em answered , that will give you an overview of the “Replication in SQL server”. Highlights of the blog:-What is replication?Why we should use Replication?What is replication Model?Replication Types And much more, also check out our upcoming series on replication for some in-depth knowledge. For…

1

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,…

10

Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher

/*** Note: Kindly follow the Instruction in each step ***/ /*** If you are using SQL Server 2008 Management Studio, Ctrl-Shift-M might not work. In that case go to “Query” menu and click on “Specify Values for Template Parameters” ***/ 1) Logon to ORACLE database as SYSDBA and follow the below steps a) Create Tablespace…

4