SQL 2000: cannot Shrink Transaction Log File
Posted on 2008-10-13
Greetings, Experts. I am in need to shrink my stubborn transaction log file. A lot of space is being eaten up by my DB's transaction log and it needs to go down in size on my server. For the last month, I've seen "a lot of growth" (for our company anyway) with the transaction log. The MDF file is 234MB and the LDF is 5.1GB.
I am familiar with SQL Server, but not to the degree that will allow me to shrink this log and not bust something in the process. This is a production database and as a result I am a nervous newbie to the idea of shrinking the log file.
So far, I've tried the following in Query Analyzer: DBCC SHRINKFILE (databasename_Log, 0)
The above action took down my transaction file about a 1/2 GB.
I seek dialog and solutions related to first taking my transaction log down in size. Once at a lower level, I'd like to see how to keep it down.
In closing, I'm not highly versed in the intricate nature of the transaction log, although I do understand its purpose. Can you assist me? I thank you kindly.