if you want to shrink database log file just run this codes with your database name:
BACKUP LOG yourdbname WITH TRUNCATE_ONLYDBCC SHRINKFILE(yourdbname_log, 2)
this code will shrink and reduce your database log file to 2MB
استفاده از مطالب سایت با ذکر منبع آزاد است