FileId      FileSize             StartOffset          FSeqNo      Status      Parity CreateLSN 
----------- -------------------- -------------------- ----------- ----------- ------ --------------------------- 
2           253952               8192                 0           0           128    0
2           253952               262144               0           0           64     0
2           253952               516096               486967      2           128    0
2           278528               770048               0           0           128    0
2           524222464            1048576              0           0           0      486967000000005700001
2           524222464            525271040            0           0           0      486967000000005700001
etc. rest all "large"

USE MyDatabaseName
GO

-- Check number of VLFs
DBCC LOGINFO()

-- Backup the LOG
BACKUP LOG MyDatabaseName TO DeviceName

-- Get name of TLog Logical Filename (NAME column)
EXEC sp_helpfile

-- Shrink the log to as small as possible
DBCC SHRINKFILE(MyDatabaseName_log, TRUNCATEONLY)

-- Re Check number of VLFs - should be only 4 I think
DBCC LOGINFO()

-- Alter the database to modify the transaction log file to the appropriate size - in one step
-- NOTE: For larger than 8GB create slightly smaller than 8GB and extend in 8GB chunks
-- NOTE *** HOWEVER *** Do not use an exact multiple of 4GB (Bug issue)
ALTER DATABASE MyDatabaseName
MODIFY FILE 
( 
	  NAME = MyDatabaseName_log 
	, SIZE = NewTotalSize	-- Whole number only, default is MB, or suffix with KB, MB, GB, TB
	, MAXSIZE = UNLIMITED
	, FILEGROWTH = 100MB

)

e.g. use 8000MB first time, to get to just short of 8GB, an then 10000MB second time - to extend that up to just short of 10GB (my desired final size)

-- Final check that there are few enough VLFs
DBCC LOGINFO()