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


MS Sql Server LazyDBA home page