Find the physical location
select name, physical_name from sys.database_files
Backup and shrink
useDBname
go
alter databaseDBname
set recovery simple
go
DBCC SHRINKFILE (DB_Log_Name
,2) --- MSSSNTI_log is the logical file name of the database
go
alter databaseDBname
set recovery full
go