Database 트렌젝션 로그 줄이기

DB 트렌젝션 로그 줄이기

-- 2000용

--BACKUP LOG VALLY_SERVER WITH TRUNCATE_ONLY

--DBCC SHRINKFILE(로그이름,1)

-- 2008용

-- 일단 DB Recovery모델을 full 에서 simple로 변경하여야 한다
select name,recovery_model_desc from sys.databases

Alter database DB이름 SET Recovery simple

select name,size from sys.database_files

DBCC SHRINKFILE (N'DB이름_log' , 1)

-- 2008용 테이블별 용량확인쿼리

SELECT CONVERT(VARCHAR(30), MIN(O.NAME)) AS TABLENAME, LTRIM(STR(SUM(RESERVED) * 8192.0 / 1024.0 / 1024.0, 15,0)) AS TABLESIZE

FROM SYSINDEXES I INNER JOIN SYSOBJECTS O ON (O.ID = I.ID)

WHERE I.INDID IN (0, 1, 255) AND O.XTYPE = 'U'

GROUP BY I.ID