SQL Query

DBCC Shrinkfile SQL Server

DBCC SHRINKFILE to shrink the transaction log file manually

Below is DBCC SHRINKFILE statement to shrink the transaction log file manually : For SQL Server 2005 : USE [DatabaseName] GO DBCC SHRINKFILE([DatabaseName_log], 1) BACKUP LOG [DatabaseName] WITH TRUNCATE_ONLY DBCC SHRINKFILE([DatabaseName_log], 1) GO For SQL…