Log reduction in SQL server

Hi All,

For Reduce the Log file in SQL server to specify size.

SELECT name, log_reuse_wait_desc FROM sys.databases where name='System ID';

EXEC sp_removedbreplication 'System ID';

SELECT name, log_reuse_wait_desc FROM sys.databases where name='System ID';

ALTER DATABASE System ID SET RECOVERY SIMPLE;

DBCC SHRINKFILE ('System IDLOG1', 1000, TRUNCATEONLY);