Open SQL Query analyser. Run the following:
-
BACKUP LOG database_name WITH NO_LOG
You can then shrink the database and the logs should decrease accordingley:
- Open enterprise manager and expand the server tree
- right click on the database > all task > shrink database
