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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
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