Hi,

I've been using the following to reduce the size of the log.

CHECKPOINT

GO

BACKUP LOG <log_name> WITH TRUNCATE_ONLY

GO

DBCC SHRINKFILE(2)

Go

The problem is that I need to do this for every log. Does anyone knows...