i just noticed that the transaction log for my baan database is very big (15Gig) and i need to shrink it and for some reason the backup job for the transaction log was failing. I looked in event viewer and can not see why it was failing. I restarted the sql agent and restarted the backup job for the transaction logs and its been saying executing for about an hour now. Does anyone know how i can tell if its working or how long it usually takes to run.

I found out the problem, and i did a transaction log backup but the ldf file is still 15 gig. i ran shrink database but that didnt do the trick. Is there another way to shrink the log file.

In SQL Enterprise manager - Truncate log

Make sure you backup afterwards as per the warning message.