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 |
|
kpgraci
Yak Posting Veteran
68 Posts |
 Posted - 2011-07-07 : 17:13:45
|
| I've read:http://technet.microsoft.com/en-us/library/ms189085.aspxand it is very informative. I'm using full recovery model, I do weekly full backups,daily differentials, and hourly tlog backups, all scheduledwith the maintenance plan wizard and run by sql agent.From the article there are several things that can prevent log truncation, but I do not believe I have met all the requirements.I also ran a manually ran a checkpoint, then did a tlog backup and still the tlog was not truncated.I've read other articles that switch to simple recovery model, then do a checkpoint, back to full, backup...way to much, this should just work.what could be preventing the log from truncating other than what is talked about in that article?kpg |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kpgraci
Yak Posting Veteran
68 Posts |
Posted - 2011-07-07 : 17:34:16
|
 I should have read the article a little closer. "Truncation does not reduce the size of a physical log file."So I did a manual shrink file in mgmt studio and it did shrink in physical size, so there was free space in the log file.thxkpg |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kpgraci
Yak Posting Veteran
68 Posts |
Posted - 2011-07-07 : 19:24:08
|
quote:
Originally posted by tkizer
Oh ok, I thought you knew that already. Hopefully your shrink is a one-time thing only. Shrinks should NOT be done regularly. If your file size is getting too big, then you need to backup your tlog more frequently or you've got large transactions that need the space.
Yeah, I'm working with limited space for now, so I just wanted to make sure the tlog backups were allowing the tlog file to not just keep growing...I won't shrink anymore now that I know it is being recylced.thx againkpg |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
truncating the transaction log 2008 r2