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