개발/DB
MSSQL 로그 삭제하기
일퍼센트
2011. 6. 30. 23:30
728x90
use DB_NAME;
go
alter databaseDB_NAME
SET RECOVERY SIMPLE;
go
DBCC SHRINKFILE(DB_NAME_log, 1 );
go
alter database DB_NAME
SET RECOVERY FULL;
go
728x90