Shrinking Transaction Log

Example and Notes

Shrinking a log file should not be routine maintenance. Review backup strategy, recovery model, log growth settings, and the cause of log expansion.

ALTER DATABASE YourDBName
SET RECOVERY SIMPLE;

DBCC SHRINKFILE (YourDBLogFileName, 100); --Log File

ALTER DATABASE YourDBName
SET RECOVERY FULL;

Production Review

WSI can adapt this script for your database, improve error handling, tune performance, document the logic, and help deploy it safely.