Huge .LDF files

[fitz_roy]

Greetings all and a Happy New Year!

I've noticed that my MSSQL folder has become humongous!
My lin2world_Log.LDF is now 30GB and there is no more room in this partition!

How do i perform maintenance on those? Are they safe to delete? (i think not).

Can you please tell me what you are doing to counter this problem?

Thanks in advance for your help.

[MentaL]

[AlphaNumero]

if i understanf correctly, those are the log files kept my mssql, just move em to another directory and start the server again, see if everything still works ok, if not then u need to keep it. i dont have the file anywhere on my system

[fitz_roy]

Thanks, i'll try it on the next restart

Tell me, haven't you noticed any change at all in MSSQL folder size over time?

[nVidiaFreak]

I have the same file, but its only ~60Megs.

[rstrst]

it's mssql transaction log file... sould be safe to delete

[fitz_roy]

i moved it to a temp directory to test thing
When CacheD loaded, it asked for the name of the DB and the user & pass, like the first time. But it wouldn't accept them!

So i am stuck with a 30GB log file that i can't find a way to remove...

Any more ideas guys? I really need your help...