October 20, 2020 at 12:00 am
Comments posted to this topic are about the item The Log File Structure
October 20, 2020 at 9:24 am
Is this question about Logical Architecture or about Physical Architecture?
October 20, 2020 at 3:55 pm
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
Haven't edited anything. I thought I had added this. Was definitely leaning towards physical structure.
October 21, 2020 at 6:31 am
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
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