I have a strange situation and I would like to get someone else taught.

I have a database that have 2 log files (I know, it should not and I plan of fixing it soon).

enter image description here

Now for what I know, log file are written sequentially (filling up one VLF then the next one) so I would expect the log file with the active VLF to fill up until it "round rubbin" into the next one but this is now what I observed.

Here's the log file usage at my first check:

enter image description here

The fact that both were used at the same percentage is the reason why I checked again a couple of minute later:

enter image description here

Why does both log file fill at the same time ?

I checked and there is no strange trace flag enable on that instance that would explain it.

Thank you for your help.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.