Hi,

you should run the script 5 times.

Your size decrease..

use YOURDBNAME

DECLARE @DB VARCHAR(40)

SELECT @DB = 'YOURDBNAME'

CHECKPOINT

EXEC('DBCC SHRINKFILE (YOURDBNAME_log, 1, NOTRUNCATE)')

EXEC('DBCC SHRINKFILE (YOURDBNAME_log, 1, TRUNCATEONLY)')

CREATE TABLE txxxx (char1 char(4000))

DECLARE @i int SELECT @i =...