Skip to content

Tag Archives: transaction log

Transaction Log bloating Pt. 2

Saturday, April 5, 2008

Just read about another cause of SQL Server 2005 Transaction Log bloating to add to my previous list.

Suspending a DB Mirroring session will prevent the primary DB from truncating its log file after a checkpoint as the log entries will be queued to be sent to the mirror DB. When the mirroring session is resumed [...]

Also tagged , , , | Comments (0)

Transaction Log bloating

Sunday, March 9, 2008

A little while ago one of my work colleges asked me why a transaction log could suddenly grow in size on SQL Server 2005 . I went with the stock standard “long running transaction” answer; then a few days latter read about another reason. And have just read about another one.

So here is my in [...]

Also tagged , , , | Comments (0)