Probably reindexing. We have a DB that grows the log from 10MB to ~70MB when we perform a weekly reindex on 300,000 records in an DB optimisation job.

BACKUP LOG northwinds TO northwinds_log_device-- or create a revolving file

BACKUP LOG  northwinds  WITH  TRUNCATE_ONLY

DBCC SHRINKFILE (northwinds_Log,truncateonly)

What's the point of the line above?

   BACKUP LOG northwinds WITH TRUNCATE_ONLY

Doesn't the previous BACKUP...