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);