Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth properly, ... log_reuse_wait_desc. ... The following query will find the name of my log file.

From a SQL Server point of view, there’s nothing you can tune. Engage the network team if there’s a long distance between servers, or the application team to check on application/server resources.