all groups > sql server replication > december 2003 >
You're in the

sql server replication

group:

dbcc opentran


dbcc opentran chris
12/29/2003 11:05:43 AM
sql server replication: sql2k sp3

Im trying to truncate a tlog on a replicated db. It wont
let me untill the results of dbcc opentran are empty. Im
the only one on this test box and can verify that all data
has made it to the subscriber. But still, even after 20
minutes of waiting, I run dbcc opentran and its not empty.
So my question is, how long after my last transaction is
committed will dbcc opentran be empty? Is there a way to
speed this up?

TIA, Chris
never mind I got it chris
12/29/2003 4:49:28 PM

[quoted text, click to view]
AddThis Social Bookmark Button