I'm using SQL Server 2008 r2's replication functionality to update my subscriber database through a transactional pull subscription. When I mark it for reinitialization, it does fix the schema and data of any modified local tables that exist in the publication snapshot, but it doesn't remove any new tables (and presumably SPs, triggers, etc.) that have been added. Is there any way to get the synchronization to remove superfluous objects like tables that don't exist in the publication shapshot, in addition to updating and adding existing objects?

  • sounds to me like what you need is to logship with a method in between where you restore the logship (so you can interact with it) and then switch back to the logship... Commented Jul 5, 2013 at 10:06

1 Answer 1


No, there's no way to do this using native functionality as replication doesn't know about the additional objects so it can't remove them.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.