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...