트랜잭션 로그 자르기

ALTER DATABASE dbname SET RECOVERY SIMPLE WITH NO_WAIT;

GO

DBCC SHRINKDATABASE(dbname, 5, TRUNCATEONLY);  

-- or

DBCC SHRINKFILE([dbname_Log, 10);

GO

ALTER DATABASE dbname SET RECOVERY FULL WITH NO_WAIT;

GO