Truncating the log

From: Paul Blackler (pblackler_at_themis.co.uk)
Date: 11/24/03


Date: Mon, 24 Nov 2003 08:39:53 -0800

Hi
Just want to make sure on something.
I have a 5Gb tranactional Log and want to truncate it and
reduce it back to a bare minimum. The procedure I want to
use is as follows :-

BACKUP LOG MyDatabase WITH TRUNCATE_ONLY

DBCC SHRINKFILE (MyDatabase_Log)

IS this okay or is there anything I am missing, it seems
to work AOK. (DSS environment)

Cheers

Paul