Log file needs shrinking

[Joell]

Hello,
I need help with shrinking the actual log file. I keep shrinking the trans logs but then it just reverts back to a 1 gig size trans log fille even after I have shrunk the file. What can I do? how do I code this in SQL?

[dbpros]

This is usually an indication that a query can be optimized. Are you running any queries that take a long time to return results? If so, they are good candidates for optimization/index tuning.

http://www.db-pros.com

[Joell]

Thank you so much! I appreciate the info. I have not started running any queries on this new software. I was told by the vendor however that the log file can grow in 1 GIG size because of all of the records in certain products that create the history in the database.
Best Regards,