T-SQL function to return name of log file for a database

ALTER FUNCTION [dbo].[UDF_DB_LOG_FILE_NAME]

(

      @dbName VARCHAR(100)

)

RETURNS VARCHAR(100)

AS

-- #author Joe Hunter

-- #version 1.0

-- #desc Return the name of the log file (.LDF) for a database

-- #param @dbName The database name

BEGIN

RETURN

(

SELECT [name]

FROM sys.master_files

WHERE DB_NAME(database_id) = @dbName

AND [TYPE] = 1 --(TYPE 1 = LDF ::jh feb 2011)

)

END