db 로그 줄이기 ( shrinkdatabase )

use DB명
 
backup log DB명 with truncate_only
 
dbcc shrinkdatabase (DB명 )


msdn
DBCC SHRINKDATABASE(Transact-SQL)