| Andrew J. Kelly 2002-06-28, 6:25 pm |
| I wouldn't force a checkpoint but you can issue BACKUP LOG YourLog WITH
TRUNCATE_ONLY to remove old entries. Usually the reason a log keeps growing
is due to a long running open transaction. Does DBCC OPENTRAN show
anything?
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
"chris" <chris@nospam.com> wrote in message
news:138f601c21ef5$c26ab8b0$3a
ef2ecf@TKMSFTNGXA09...
>
> i've got a log file on tempdb that is running away on me.
> i found that the log is truncated on checkpoint and the
> recovery model is always and only set to simple.
>
> if i manually force a checkpoint the log will truncate.
> (in QA execute 'use tempdb go checkpoint').
>
> however it is not truncating on it's own.
>
> the data file fluctuating up and down between 5 and 20mb,
> the log is growing by 10mb every 10 minutes or so and only
> going one way...
>
> any ideas why?
>
|