MS SQL 7.0 Log file

[cvankrieken]

Hi,

My .ldf log file has grown out of proportion (around 9 Gb ) and my diskspace has run out... How can I solve this and how can it be prevented ?

C.

 

[tlbroadbent]

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.