The Log File Structure

  • Comments posted to this topic are about the item The Log File Structure

  • Is this question about Logical Architecture or about Physical Architecture?

  • It says "physical structure" in the question - at least it does now, not sure if it was edited.

    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"

  • Haven't edited anything. I thought I had added this. Was definitely leaning towards physical structure.

  • Then what does 'physical structure' mean according to Ref link where Architectures are described only?

    Logical Architecture:

    The SQL Server transaction log operates logically as if the transaction log is a string of log records.

    Physical Architecture:

    Conceptually, the log file is a string of log records. Physically, the sequence of log records is stored efficiently in the set of physical files that implement the transaction log.

    The SQL Server Database Engine divides each physical log file internally into a number of virtual log files (VLFs).


  • hmm...

    As one of those who selected the VLF answer, I like the way you think! Though I have to confess I only ever thought there was a physical structure.

Viewing 6 posts - 1 through 5 (of 5 total)

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