CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
tempdb log file getting LARGER
|
chris
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
 tempdb log file getting LARGER
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?
Report this post to a moderator
|
|
 06-28-02 10:25 PM
|
|
Andrew J. Kelly
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: tempdb log file getting LARGER
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?
>
Report this post to a moderator
|
|
|
06-28-02 11:25 PM
|
|
|
Featured site: MCSE, MCSD, CompTIA, CCNA training videos
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF. |
|
ExamNotes forum archive
|
