Page History: MS-SQL LDF파일 축소
Compare Page Revisions
Page Revision: 2012/05/17 20:48
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