Bipul Raman BipulRaman

## bipul.in_Trunckate_Database_Logs.sql
USE WSS_Content_DB
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE WSS_Content_DB
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (WSS_Content_DB_Log, 1);
GO
-- Reset the database recovery model.
	USE WSS_Content_DB
	GO
	-- Truncate the log by changing the database recovery model to SIMPLE.
	ALTER DATABASE WSS_Content_DB
	SET RECOVERY SIMPLE;
	GO
	-- Shrink the truncated log file to 1 MB.
	DBCC SHRINKFILE (WSS_Content_DB_Log, 1);
	GO
	-- Reset the database recovery model.