If you encounter log space issue and if you have more than 1 log file for a database, how would you deal with it?
In my scenario, I have a database which has 2 log files in 2 different drive, I am not sure who created this....I know more than 1 log file won't help performance since logs are generated sequentially..
Anyway, my question is this......the second log file that host the drive has enough free space, however, the first log file drive is running out of space and this is creating the alert. How would you deal with this situation? Please share your experience.