Can never remember the syntax so here is is as a reminder:
Make the database current then run
DBCC
SHRINKFILE(‘Foo_LOG’,1)
BACKUP
LOG Foo WITH TRUNCATE_ONLY
DBCC
SHRINKFILE(‘Foo_LOG’,1)
go
Do people not realise you can tax your bloody car online these days without moaning at the Post Office? #waiting or perhaps they can't read!