I have a database with 200 MB data file size and 120 GB transaction log file.I wonder why?This database is a part of the Data warehouse project and cubes are reffering to it.
Is there any advantage of keeping such a big log file?
If you have the recovery plan set to full and don't baskup the log then it will just keep growing.
It will also not shrink unless you tell it to - so if you had a long running transaction in the past it would grow and stay there.
Set the recovery model to simple to keep the tr log small if you don't want to recover transactions.
Look at dbcc shrinkfile to shrink the log.
a detach, delete log file and attach single file will do the same thing.