Post reply

In transactional replication - first 8000 rows of snapshot copies to subscriber snapshot then acts like it completed successfully

  • October 31, 2011 at 6:00 pm

    #390731

    In transactional replication - first 8000 rows of snapshot copies to subscriber snapshot then acts like it completed successfully.

    Publication table has 21 million rows. Snapshot says completed successfully then we get the error "cannot find row at the subscriber" when transaction replication begins.

    This is on a new 64 bit server running SQL Server 2005 Standard 64 bit SP3 with Cummulative Update 4. We have a standalone distributor also.

    We upgraded the server / OS to Windows 2008 R2 64 bit and SQL Server from 32 to 64bit with the Cummulative Update 4 to take care of the paging issue/bug.

    Has anyone ever ran into this situation?

  • November 10, 2011 at 6:46 am

    #1405712

    I have never faced this issue. We have done snapshots for tables that have millions of rows but we usually try to do the population by ourself if we can and tell the snapshot agent not to do a snapshot.

    -Roy

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

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