[MS-SQL] log 파일 용량 줄이기...축소
ALTER DATABASE limc SET RECOVERY SIMPLE
go
DBCC SHRINKFILE(limc_log, 10)
go
ALTER DATABASE limc SET RECOVERY FULL
go
////////////////////////////////////////
ALTER DATABASE nzdb01 SET RECOVERY SIMPLE
DBCC SHRINKFILE(nzdb01_log, 50)
ALTER DATABASE nzdb01 SET RECOVERY FULL
EXEC SP_HELPFILE
go
DBCC SHRINKFILE(limc_log, 10)
go
ALTER DATABASE limc SET RECOVERY FULL
go
////////////////////////////////////////
ALTER DATABASE nzdb01 SET RECOVERY SIMPLE
DBCC SHRINKFILE(nzdb01_log, 50)
ALTER DATABASE nzdb01 SET RECOVERY FULL
EXEC SP_HELPFILE