#4.Script to get log file growth details of all databases in SQL

Why?

I came across a situation that i want to know current max growth settings of my database log files. To make it easier in look & avoid extra details i made a simple query which use two base tables in MASTER Database & give us required info.

Script :

Use master
-- Creating temporary table named LOG_FILES_DETAILS

Create Table Log_files_details
( database_name varchar(225),
Log_File_Name Varchar(225),
size_MB decimal,
Max_size decimal,
growth int,
Recovery_model Varchar(225),
 )

-- Inserting values to temporary table

INSERT INTO Log_files_details (database_name,Log_File_Name,size_MB,Max_size,growth,Recovery_model)
Select T2.Name,T1.Name,(T1.Size*8)/1024 ,T1.Max_size,T1.growth,T2.recovery_model_desc
FROM sys.master_files T1
INNER JOIN sys.databases T2
ON T1.database_id=T2.database_id
where T1.[type_desc]='LOG';

-- View the data in log file table

Select * from Log_files_details


-- delete Log_files_details

Drop table Log_files_details
------------------------------------------------------------------------------------------------------------

Thanks for coming till this point !!

VSG 

SQL DBA.