November 29, 2006 at 12:30 pm
I have a transactional replication set up and works fine. But the issue that I have is when I run dbcc opentran on publisher database I get a message stating an Old Replicated Transaction is still open.
I deleted the replication and set it up from scratch and found out it starts happening as soon as log reader picks up a transaction. During initialization and after initialization I did not see any open transaction.
Can any one tell me how this can be corrected. I've set up transactional replication on bigger tables before (On another assignment) and have never run into this. The problem with Open transaction is that log can potentailly start growing and I want to find the issue and fix it.
Thanks
Sreejith
December 1, 2006 at 11:09 pm
I think you can use sp_repldone command but becareful this may invalidate log but not sure...
Google sp_repldone you should more info...
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply