Try DBCC SHRINKFILE() without the TRUNCATEONLY option.

-Mike


>Hi,
>
>Does anyone know how to clean the logfile of an sql server 2000 ?
>
>I tried the steps below but the logfile still maintains it size of 12GB Compared to the size of the database which is only 1.2GB
>
>Step1 - Backup Transaction Log then Backup the Database (Complete)
>
>
>Step2 - used the DBCC ShrinkFile command in SQL Query Analyzer
> DBCC SHRINKFILE(SMARTAPP_LOG,30,TRUNCATEONLY)
>
>Step3 - used the DBCC ShrinkDatabase command in SQL Query Analyzer
> DBCC SHRINKDATABASE(SMARTAPP,50,TRUNCATEONLY)
>
>I tried all of these steps but it does not work. Any Idea?
>
>
>Thanks in advance...