Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Unanswered: Having two log files

    Morning guys,
    Trying to get pointed into the right direction when understanding how a database writes to a transaction log when you have more then one on separate disks.
    I created a second transaction log and would like to know how the database knows when to write to one or the other.... ?
    Any search strings that could assist or articles.. would be great
    thanks,
    Jonathan

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Google Paul Randall and (I think) Kimberly Tripp and Kalen Delaney regarding this. I've read articles by some or all of them that essentially state that multiple log files are utterly pointless.

    IIRC only once one is "full" (cannot grow) will the database write to the second log - as such it is a serial not parallel process.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Interesting

    Thanks,
    pootle flump
    I guess if one drive is running out of space and the transaction log cannot grow anymore on that drive then it will write to the second log on another drive with space. If this is the scenario then it serves some purpose if not then as you said utterly pointless ........

    Jonathan

Posting Permissions

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