By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,341 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

Log file needs shrinking

P: 31
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?
Jun 20 '08 #1
Share this Question
Share on Google+
2 Replies


P: 15
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
Jun 23 '08 #2

P: 31
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,
Jun 29 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.