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... – Andrew Bickerton Jul 5 '13 at 10:06

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, privacy policy and cookie policy

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