I'm using the SQL Server 2000 and have 4 datebase on it.
But the transaction log file size about 4GB, how can I
clean up. (because they make the server hang up)

Thanks a lot
Sunny

Sunny,

backup log YourDatabase with truncate_only

Refer to Books Online for syntax details.

If you are using full recovery model, you need to back up the
transaction log on a regular basis to keep it down to a reasonable
size. Or switch to simple recorvery model after truncating the log.


Linda