Solved

Transactional Replication - Data not copied

Posted on 2009-07-05
1
212 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 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql user function 7 31
SQL Update Query - What's wrong with this. 18 20
affinity mask in sql server 1 22
Find data in a column which is not in  a date format 29 0
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now