SELECT file_id, name FROM sys.database_files
BACKUP LOG [databaseName]
TO DISK=‘nul:’ WITH STATS= 10
DBCC SHRINKFILE(‘templog’, 0, TRUNCATEONLY)
IT Professional
SELECT file_id, name FROM sys.database_files
BACKUP LOG [databaseName]
TO DISK=‘nul:’ WITH STATS= 10
DBCC SHRINKFILE(‘templog’, 0, TRUNCATEONLY)