Log file needs shrinking

Question posted by: Joell (Newbie) on June 20th, 2008 02:54 PM

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?

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

dbpros

Newbie

15 Posts

June 23rd, 2008
11:28 PM
#2

Re: Log file needs shrinking

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

Newbie

27 Posts

June 29th, 2008
03:18 PM
#3

Re: Log file needs shrinking

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,

Not the answer you were looking for? Post your question . . .
182,256 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Top Microsoft SQL Server Contributors