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 |
|
msr976
Starting Member
2 Posts |
 Posted - 2008-02-29 : 10:27:59
|
| I am having problems with the transaction log growing. I set up a maintenance plan to backup every 15 minutes. The recovery model is set to full. It is set to auto grow by 10 percent with unrestricted file growth. The space allocated is 2mb. Should this be set higher? It seems whenever I unchecked the auto shrink, the log is growing larger. The command I use to check is: SELECT * FROM sysfilesWHERE name LIKE '%LOG%' GOThis is the log size and the log space used.1.4921875 38.02356This has grown 4 percent since yesterday. Are there any good practices to maintain these log files? Any help would be appreciated.msr976 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-29 : 16:06:56
|
| Never have the autoshrink option selected in a production environment. You are causing performance issues by having this selected since obviously the database needs that space.Why is 4% growth a big deal?2MB is way too small for a transaction log file. I've got some LDF files that are 20GB in size. You are already doing what you can to manage the size of the file by backing it up every 15 minutes. Now let it grow to what it wants to be at!Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Transaction log growing