Solved

Transactional Replication - Data not copied

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
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.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 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