Post reply

Tran Replication - data not copied

  • July 4, 2009 at 4:30 pm

    #207885

    i used a script for transactional replication and successfully replicated 3 tables from sql 2000 to sql 2005.

    but when i tried the same script for other table it doesn't work.

    the table has a primary key and the agent jobs are running continuously.

    the snapshot was also applied and it even showed bulk copy of 213 rows in replication monitor.

    the log reader agent is also running.

    but when i check the table is not created at all..

    please help me how to figure it out or troubleshoot it.

  • July 5, 2009 at 10:13 pm

    #1020194

    I kinda suspect that you have not add a scription for the 4th table. The record count you saw is probably the bulk copy of the data from the source table to the snapshot file. Try adding the 4th table to the subscription you created. You should be able to do this with either Management Studio or Enterprise Manager.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply