Home Forums SQL Server 2008 SQL Server 2008 High Availability Replicated data duplicating on subscriber? RE: Replicated data duplicating on subscriber?

  • March 21, 2013 at 5:53 am

    #1599340

    Erin Ramsay (3/20/2013)

    As a follow-up example.

    I have a table, call it tableA, that contains 1 million rows on my publisher and uses 103 MEGs of data space.

    tableA in the subscriber database also contains 1 million rows and uses 11 GIGS of data space.

    Neither the publisher or the subscriber tables have indexes or primary keys. They are structurally identical.

    Thoughts? Help?

    Transactional replication requires primary key.

    SueTons.

    Regards,
    SQLisAwe5oMe.