edit/minimize transaction log file

[marknav]

Hi
My database's transaction log file is too big.
there is no space on the disk for it to grow, and other operations can not be made.
i tried to truncate the file but it didn't do anything .
i was also thinking to change in the DB properties the location of the file , so it will be saved on a different disk, but it didnt let me .
What is the solution to a case like that???
Thank you

 

[tlbroadbent]

You need to shrink the log as well as truncate the transactions. See faq183-1534 - "Shrinking Databases and Logs - SQL 7 and Higher."
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.