SQL Server Log 파일 축소하기

2005 이상 버전에서만 적용

alter database [database name] set recovery simple
go

dbcc shrinkfile([database log name], 1)
go

alter database [database name] set recovery full
go

ex)
use tsdms_New;
alter database tsdms_new set recovery simple;
dbcc shrinkfile (tsdms_new_log, 1);
alter database tsdms_new set recovery full;

use vims;
alter database vims set recovery simple;
dbcc shrinkfile (vims_log, 1);
alter database vims set recovery full;