Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006

    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?


  2. #2
    Join Date
    Sep 2002
    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.

  3. #3
    Join Date
    Mar 2006
    Thank you very much for your respond.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.