Improve company productivity with a Business Account.Sign Up

x
?
Solved

Transactional Replication - Data not copied

Posted on 2009-07-05
1
Medium Priority
?
231 Views
Last Modified: 2012-05-07
Hi,

I have implemented "Transactional Replication" using a script for 4 tables on SQL Server 2000 to SQL Sevrer 2008. I have created 4 publications and placed each table as 1 article in each publication:

3 tables are replicated and showed in the subscriber database. But the 4th table is not getting copied. It is a standard push subscription with no updating. For the 4th table there is a primary key and the snapshot is being applied and in the replication monitor i can see there is a buk copy of 213 rows with no errors, even the log reader agent is working fine with no errors reported. But the table is not getting copied in the subscriber database.

There are no triggers at the subscribers database and the data in the database are the 3 tables i have replicated.

I am new to replication and any trouble shooting steps for this scenario is much appreciated !

Thanks
0
Comment
Question by:milani_lucie
1 Comment
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 1500 total points
ID: 24782196
>>  i can see there is a buk copy of 213 rows with no errors

Then its failing in the subscriber database and glad you checked for triggers.
Kindly check for other related causes like

1. Primary Key violation / Identity Duplicate issues.
2. Foreign Key violations.
3. Check Constraint Violations.
4. Not Null violations.

Hope this helps
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question