use [DB명]
backup log [DB명] with truncate_only dbcc shrinkfile ([DB 로그명], truncateonly)
---------------------------------------------------------------------------------
Use master
Backup LOG [데이터베이스명] with truncate_only
Use [데이터베이스명]
DBCC SHRINKFILE([로그파일명],[사이즈(MB단위)])
댓글목록
슈퍼아이피님의 댓글
MSSQL 2008일경우
use StatusLog
alter database StatusLog set recovery simple
go
dbcc shrinkfile (2, 10)
go
alter database StatusLog set recovery full
go