SQL Server Log 파일 축소하기

DATABASE/SQL Server 2013. 6. 26. 14:32

2005 이상 버전에서만 적용


alter database [database name] set recovery simple
go


dbcc shrinkfile([database log name], 1)
go


alter database [database name] set recovery full
go


ex)
use tsdms_New;
alter database tsdms_new set recovery simple;
dbcc shrinkfile (tsdms_new_log, 1);
alter database tsdms_new set recovery full;

use vims;
alter database vims set recovery simple;
dbcc shrinkfile (vims_log, 1);
alter database vims set recovery full;

: