March 21, 2013 at 10:33 am
We have a server that we just recently setup transactional replication on and we have begun to see that the T-Log is not logically truncating in a timely manner. We removed the subscriber hoping to resolve the issue temporarily, but it doesn't seem to have resolved the issue.
I have two questions:
1. What officially has to happen for a transaction to be marked replicated?
2. What is the minimum operation to remove the hold on the offending transactions?
Thanks for all the help,
Dane
March 21, 2013 at 10:44 am
Found this on books online:
Transactional Replication and the Transaction Log
If a database includes one or more transactional publications, the log is not truncated until all transactions relevant to the publications have been delivered to the distribution database. If the transaction log is growing too large, and the Log Reader Agent is running on a scheduled basis, consider shortening the interval between runs or setting it run in continuous mode. If it is set to run in continuous mode (the default), ensure that it is running.
Hopefully this helps someone later!
-Dane
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply