GilaMonster (7/12/2012)
SQLRNNR (7/12/2012)
GilaMonster (7/12/2012)
@SQLFRNDZ (7/12/2012)
Ther must be an open transaction that is filling your log, DBCC opentran.
If there was, log_reuse_wait_desc would have returned "Open Transaction", not nothing.
In most cases. Though the opposite, I have seen opentran return nothing and log_reuse_wait_desc show 'Replication' or 'Active Transaction'
Yes, it doesn't update immediately. Sometimes requires a checkpoint to update (and to actually truncate the log in simple)
Thanks for explaining that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events