[Database][SQL Server] Log file filesize too big

Deskripsi
     i not recommend use shrink but if it urgent you can use it because it effect reduce perfomance to database.

How to 
1. run query , to get physical name of files data or log.
select name from dbname.sys.database_files where type=1

2. to use shrink use this 

Backup log dbname with truncate_only

go

DBCC shrinkfile('logicalfilename',100)

but it still not recommend use shrink , you must give a limitation of the autogrowth file data / log !!