Out of curiosity, have you implemented the Trace flag -T1118 and used
multiple multiple datafiels with the tempdb? If so you may want to put
int sp4 if you havent I recall an issue with that a while back...

-----Original Message-----
From: Mahmood Jaffer (SoftLanding)
[mailto:mssqldba-ezmlmshield-x63531998.[Email address protected]
Sent: Monday, April 30, 2007 10:49 AM
To: LazyDBA Discussion
Subject: RE: TEMPDB Log

Yeah that works. Wondering why SQL server isn't issuing a checkpoint.


-----Original Message-----
From: trainr [mailto:mssqldba-ezmlmshield-x85663782.[Email address
protected]
Sent: Monday, April 30, 2007 10:45 AM
To: LazyDBA Discussion
Subject: Re: TEMPDB Log


Nope. Have you tried just running the CHECKPOINT command?

Quoting "Mahmood Jaffer \(SoftLanding\)"
<mssqldba-ezmlmshield-x63538934.[Email address protected]

> Hi Everyone,
>
> Any anyone run into an issue with SQL 2000 failing to issue a
> checkpoint for tempdb log at 70% capacity? I wanted to check with you
> guys before calling PSS.
>
> Thanks
> Mahmood
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post

> a dba job: http://jobs.lazydba.com To subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the exclusive and confidential use of the addressee. Any other distribution, use, reproduction or alteration of the information contained in this electronic message, by the addressee or by any other recipient, without the prior written consent of the sender is strictly prohibited. If you have received this electronic message in error, please notify the sender.


MS Sql Server LazyDBA home page