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

Replication skips re-created tables Expand / Collapse
Author
Message
Posted Tuesday, February 05, 2013 6:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:41 AM
Points: 7, Visits: 91
Hallo
I have snapshot replication from A to B.
Everything ran fine, until someone (the software vendor) in A dropped and recreated (identically) some tables being replicated.
Replication gave no errors, the articles are still checked in the Publication properties window, but those tables are not replicated since than.
Since this situation will occur again, how could I manage it?

"B" Database is used only for reading, no data editing, hence I'd be considering a quick&dirty Drop table + INSERT INTO via LinkedServer, even because only 100 tables are involved with small amount of data.

Thanks in advance
Post #1415802
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse