Roy Ernest (11/26/2009)
The only thing that could keep it big then is that there are some commands that are that has not been replicated yet. What is your retention period?
Hi Roy,
Thanks for your reply.
For many of the publications, retention period was "subscription never expires". Just now I changed it to 72 hrs.
msrepl_transactions table has 13 million rows and msrepl_commands table has 31 million rows.
There are 51 rows in msrepl_transactions with entry_time older than 2009-06-07. Oldest is 2006-06-26
Will changed retention period fix the issue?
Regards,
Suresh