Two ways to shrink SQLServer2000 database logs

server|sqlserver| Data | Database with command line:

For database log files, such as: Database name: PUB; log file name Pub_log, currently 100M, to compress to 10M
First step: Truncate the transaction log
In SQL Query Analyzer, perform the backup LOG PUB with TRUNCATE_ONLY
Step two: Shrink the database log to a specified size
In SQL Query Analyzer, perform DBCC SHRINKFILE (pub_log,10)

With Enterprise Manager:

Right-click the database you want to shrink, select all tasks, shrink the database, click "File" below, select the file to shrink in the dropdown box (data file or log file), OK. To compress multiple files, repeat the operation several times.