Database/MS SQL Server2014.06.23 10:56




트랜잭션 로그 사이즈 줄이기

 

USE [CasDB] 
GO 
ALTER DATABASE [CasDB] SET RECOVERY SIMPLE WITH NO_WAIT;
DBCC SHRINKFILE(CasDB_LOG, 1);
ALTER DATABASE [CasDB] SET RECOVERY FULL WITH NO_WAIT;
GO 




Posted by 금붕어70