But once you drop it, you lose the unreplicated transactions. Basically, you are screwed. You will have to resynch the data and create the subscription again.