Post reply

DBCC loginfo

  • May 21, 2004 at 7:09 am

    #85585

    I've been using this useful undocumented DBCC command recently but the only information I can find on the Status column it returns, is that above 0 means that the virtual log is in use.

    Now all the VLF's I examined had a status of 2 and these we're not uncommitted or undistrubted, just not backed up.   These returned to a status of 0 when backed up.

    So, does anyone know what the values in the Status field mean?  How is say 1 different to 2?  What other values can it take?

    Graham Davies

    DBA, Pearson Shared Services, London

     

  • May 21, 2004 at 7:52 am

    #507277

    From some searches, it appears nobody knows. In fact, you seem to have more information than most. Care to write an article on your experiences?

    I'd guess that a 2 means it's committed, but not backed up, so it's part of the active log. Active meaning, needed for recovery. A 0 would be committed and backed up, so not needing to be part of recovery in the current log. I'd guess there's a status for something in use. Can't think of another status right now.

     

  • May 21, 2004 at 9:36 am

    #507314

    I'm wondering if this will tell me whether a VLF is backed up, committed, uncommitted and unreplicated or something like that.

    Graham.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply