MysteryJimbo (11/25/2013)
Are there any distribution db backups? If so there is an MS article on how to restore it.Will the data have changed on the published databases? If not, you can create a new distributor and rebuild replication. Add the subscribers with a @sync_type of 'replication support only' which will only recreate the subscriber procs but not touch the data or require a snapshot.
We have the latest backup of distribution database. But the data on publisher changes every minute and also as the distributor will not be available, it will be hard for us to clear the orphan publications and subscriptions and the publisher can have only one distribution server. So first we have to clear the publications not to use distributor and remove the publisher from replication.
Can you please provide the link for that MS article ? Thanks.