You can use the DBCC SHRINKFILE() command to reduce the physical size of the transaction log.

Before doing so, you need to determine why your transaction log is so large? Are you doing periodic transaction log backups? Maybe you're doing large data loads?

-Mike

>Transaction log is very big as it is taking tens of giga bytes of space. How can I reduce the size?
>
>Thanks
>Bharat