Script to configure Log File Size for Large DBs

SET NOCOUNT ON;
DECLARE @_Database_Name SYSNAME = NULL
,@_Max_Log_Size_GB INT = NULL
,@_Execution_Query NVARCHAR(2000) = ''
,@_Logical_File_Name SYSNAME
,@_Size_Counter_GB INT = 8
,@_File_Size INT

--Provide DB Name & Max Log file size
SET@_Database_Name = 'Test'
SET     @_Max_Log_Size_GB = 230

IF (SELECT COUNT(1) FROM SYS.sysdatabases WHERE name = @_Database_Name) = 1
BEGIN

SELECT@_Logical_File_Name = name
FROMsys.master_files 
WHEREDB_NAME(database_id) = @_Database_Name
ANDtype_desc = 'LOG'

WHILE (@_Size_Counter_GB <= @_Max_Log_Size_GB)OR((@_Size_Counter_GB-@_Max_Log_Size_GB)<8)
BEGIN
IF (@_Size_Counter_GB <= @_Max_Log_Size_GB)
SET@_File_Size = @_Size_Counter_GB*1000
ELSE
SET@_File_Size = (@_Max_Log_Size_GB - (@_Size_Counter_GB-8))*1000

SET@_Execution_Query = '
USE master;
GO
ALTER DATABASE ['+@_Database_Name+'] 
MODIFY FILE
(NAME = ['+@_Logical_File_Name+'],
SIZE = '+CAST(@_File_Size AS VARCHAR(10))+'MB,
FILEGROWTH = 8000MB
);
GO
';

PRINT @_Execution_Query
SET @_Size_Counter_GB += 8
END

END
ELSE
THROW 50000,'Provided Database does not exists',1