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 |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2011-02-21 : 22:18:57
|
| One of the Database who has its LDF growth by almost 80 Percent of the MDF size.Even after shrinking, the log file tends to grow abnormally.Can anyone advise me how to control this growth.Thanks. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-22 : 02:22:12
|
| Can you let us know about the following1) Recovery Model of your database?2) How often you takes the database backups and what type of backups do you take? |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-02-22 : 15:59:52
|
| It sounds like your database is set to full recovery model and you are not performing frequent (every 15/30 minutes) transaction log backups.If your database is set to simple recovery, then your log file needs to be that size to handle the transactions.Jeff |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2011-02-22 : 18:28:06
|
| The Database is in FULL recovery model and Procures Full Backups once in the evenings and every 15-Minute gets Log Backups.Yes. Reindex needs this space around (may be 80 Percent) but this was not the case in the past when Reindex process is in place.Alternatively, may be the Reindex process should be dealt as once the reindex is finished then should apply the SHRINK process.Is this good?Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2011-02-22 : 18:49:49
|
| Thanks to all Participated. |
|
|
|
|
|
|
Log File Growth