MS SQL 로그 삭제
2009. 9. 7. 01:21ㆍ카테고리 없음
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
흠.. 왜서 바뀌어서..ㅡ.ㅡ;;;
다시 찾았네..ㅡㅡ;;;
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
흠.. 왜서 바뀌어서..ㅡ.ㅡ;;;
다시 찾았네..ㅡㅡ;;;