트랜잭션로그 삭제하기

exec sp_helpfile
select * from sysfiles

use love2flower_com
backup log love2flower_com with truncate_only

dbcc shrinkfile(love2flower_com_Log,2)

\====================================
원래는 이렇게만해도 실행이 됨

exec sp_helpfile
select * from sysfiles

dbcc shrinkfile(love2flower_com_Log,2)