Mac1986 (10/29/2012)
Hello Master Gail: Thanks a million for such beautiful article on log behavior.Quick Question: I have seen a situation where the there is no replication setup on the DB . CDC is wnabled. and the log_reuse_wait_desc shows as 'Replication'..
As per the article, undistributed transaction is causing the Log Growth. how can i check if which undistributed LSN ((43831:51:1) in my case) provided in DBCC OPENTRAN output is pointing to DDL operations of type ALTER TABLE.
how can i relate and compare the LSN in OPENTRAN with DDL Operation
Please have your comments on this..
Please don't post in multiple threads for the same problem. I answered you in the thread you started, please keep the discussion there for simplicity and clarity.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability