Hi,
i'm running 12 sql server replications, 11 of which have 1 subscription, and 1 has 2 subscriptions. Now i have a problem with a very large transaction log which i want to shrink, but i get the messages that the transaction log is in use. I suspect that the replication (publication, maybe the subscription too) is causing this problem.
Now the only way i found to stop publication does DROP alle publications, but that is something more then i wanted: to pause the publication.
Is there a way to accomplish this?