November 28, 2011 at 12:58 am
HI All
I know that if status =2 for dbcc loginfo it means that that VLF is in use i just want to know that when entry is created for create LSN column every time Attached the screen shot for My DB..
AS you can see in my attachment i can understand that after taking log back up all inactive VLF are truncate i just want to know why row third is showing status 2 and Fseqno-361.Even though i do not have active transaction i ran many time log back up again but now cant truncate VLF for fseqno-361
November 28, 2011 at 8:56 am
Please can i have some one expert guidance here..!!
November 28, 2011 at 11:33 am
There will always be at least one VLF that is inuse - it is probably the one you are looking at.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
November 28, 2011 at 12:06 pm
Thanks but may i know the reason for it and why pointer is move to third row in my screen shot thanks again
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply