개발/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