Post reply

The Log File Structure

  • October 20, 2020 at 12:00 am

    #3792117

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

  • October 20, 2020 at 9:24 am

    #3799159

    Is this question about Logical Architecture or about Physical Architecture?

  • October 20, 2020 at 3:55 pm

    #3799324

    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?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • October 20, 2020 at 5:10 pm

    #3799353

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

  • October 21, 2020 at 6:31 am

    #3799571

    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).

     

  • October 21, 2020 at 5:17 pm

    #3799810

    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