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 |
|
Minesalatte
Starting Member
10 Posts |
 Posted - 2008-08-20 : 06:27:29
|
| Hi,I can't seem to get my head around transaction logs and how they recycle space. I always seem to need to shrink it. I use the simple recovery model which as I understand has automatic checkpoints where it ?clears out transactions that have been commited? which should allow me to reuse the space.Is this correct and if so is there a way to specify the frequency of these automatic checkpoints?Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-20 : 12:30:48
|
| That is correct. Don't shrink the log file as obviously it needs the space. Add additional disk space if you are tight.What version of SQL Server are you using? Do you have an optimizations job in place?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
Minesalatte
Starting Member
10 Posts |
Posted - 2008-08-20 : 12:50:32
|
| Thanks for your response.I don't have an optimizations job in place that I'm aware of, is this what controls the automatic checkpoints?I have SQL 2005 standardThanks, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-20 : 12:57:58
|
| No, but it can grow your log to be as much as 1.5 times bigger than your mdf file. How big is the MDF and how big is the LDF?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
Simple recovery automatic checkpoint setting