MS-SQL LDF파일 축소

Modified on 2012/05/17 20:48 by Administrator — Categorized as: Database


backup log 디비명 With TRUNCATE_ONLY




sp_helpdb 디비명



DBCC SHRINKFILE (test_log, 5)

예) backup log DBNAME With TRUNCATE_ONLY

sp_helpdb DBNAME

DBCC SHRINKFILE (DBNAME_Log , 5)

windows 2008

alter database DBNAME 
set recovery simple;
go

DBCC SHRINKFILE ('DBNAME _Log', 2)
go

alter database DBNAME 
set recovery full;
go