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
Author
Message
Posted Thursday, March 21, 2013 5:53 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 405, Visits: 2,492
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.
Post #1433742
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse