We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

USE [DB1];

SELECT
	DbName = DB_NAME()
,	TotalFileSizeMB = SUM( CONVERT( DECIMAL( 12, 2 ), ROUND( a.size / 128.000, 2 ) ) )
,	TotalSpaceUsedMB = SUM( CONVERT( DECIMAL( 12, 2 ), ROUND( FILEPROPERTY( a.name, 'SpaceUsed' ) / 128.000, 2 ) ) )
,	TotalFreeSpaceMB = SUM( CONVERT( DECIMAL( 12, 2 ), ROUND( ( a.size - FILEPROPERTY( a.name, 'SpaceUsed' ) ) / 128.000, 2 ) ) )
FROM 
	sys.database_files a 
WHERE
	a.[type_desc] = 'LOG';

BACKUP LOG databasename TO devicename;

DBCC SHRINKFILE(transactionloglogicalfilename, TRUNCATEONLY);

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

DBCC SQLPerf(LogSpace)

CREATE GarbageTable (...)

INSERT INTO GarbageTable ... -- lots of rows, not 1 or 2

TRUNCATE GarbageTable

We walk in the dark places no others will enter
We stand on the bridge and no one may pass