Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Replicated data duplicating on subscriber? Expand / Collapse
Posted Thursday, March 21, 2013 5:53 AM


Group: General Forum Members
Last Login: Thursday, August 27, 2015 12:52 PM
Points: 438, Visits: 2,708
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.


Post #1433742
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse