-
Transaction Log Files
Hi All,
I am trying to understand the difference between the physical, logical and virtual logs. I found some info in BOL, but I am still a little bit confused.
What is the physical file? Is each transaction considered a physical file?
Each physical log file consists of a number of virtual log files.
Then what about the logical log? When does it come into play?
Thanks.
-
Each db file has logical name and physical name. For instance, logical file name of pubs db's log is pubs_log while physical name is pubs_log.ldf. Sql server uses logical name internally, and you can find both names in sysfiles1 table.
-
Thank you very much for your respond.