MS SQL 로그 삭제

USE HiNetERP; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE HiNetERP SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (HiNetERP_Log, 10); GO -- Reset the database recovery model. ALTER DATABASE HiNetERP_Log SET RECOVERY FULL; GO 흠.. 왜서 바뀌어서..ㅡ.ㅡ;;; 다시 찾았네..ㅡㅡ;;;

2009.09.07