MS SQL 2008 트랜젝션 로그 줄이기

MSSQL 2008 의 경우

USE [DataBase]; GO — Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE [DataBase] SET RECOVERY SIMPLE; GO — Shrink the truncated log file to 10 MB. DBCC SHRINKFILE ([DataBase_Log], 10); GO –Reset the database recovery model. ALTER DATABASE [DataBase] SET RECOVERY FULL; GO

 

* MSSQL 2005 의 경우

use [DB명];
sp_helpfile;

backup log [DB명] with no_log;
dbcc shrinkfile ([로그파일명], 10);