Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
flanz_g
Starting Member
22 Posts |
 Posted - 2007-02-07 : 06:46:00
|
Hi,My SQL2000 DB limit is 50GB. I can see I have used under 30 but Avaibale space is only about 11!? The Transaction Log file has taken over 1/5 of my "precious" space. Could you advise why TLF has grown so big? Is it always relative to used space or somethig else as well? What purpose does it serve?Can I shrink it or how about bkp and Delete it?Appreciate any helpGezza  |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-07 : 07:12:09
|
| See:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Why%20is%20my%20LDF%20Log%20File%20so%20bighttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Database%20Shrinking,Shrink,ShrinkingI normally work on a rule-of-thumb that the Log file (LDF) being up to 120% of the Data file (MDF) is "acceptable"Backing up your Log file will not shrink it (but it will make the used-space available for re-use). Constantly shrinking, and regrowing, the log file is bad for performance and fragments the files - so better to find the right size so that the files stay in equilibriumKristen |
 |
|
|
|
|
|
Transaction Log File.. and what else?