Re: Checkpointing Not Happening in Simple Recovery Model

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 12/26/04 

Date: Sun, 26 Dec 2004 08:00:30 -0500

She says that she has simple recovery and that one of them is tempdb. Maybe
the next thing we should look at is doing sp_helpdb. 

-- 
   Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON   Canada
www.pinnaclepublishing.com
.
"Daniel Joskovski" <omnis@NOSPAMunetREMOVECAPS.com.mk> wrote in message 
news:uevSRcu6EHA.2012@TK2MSFTNGP15.phx.gbl...
Yes, you are right, I read that Michelle is writing about logs not log, is
there possibility that she looks at transaction logs on databases with full
or bulk logged recovery model?
Regards,
Daniel
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:ONo0e4b6EHA.1392@tk2msftngp13.phx.gbl...
> You cannot set the recovery model in tempdb.
>
> -- 
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
>
> "Daniel Joskovski" <omnis@NOSPAMunetREMOVECAPS.com.mk> wrote in message
> news:u5NjKcV6EHA.2624@TK2MSFTNGP11.phx.gbl...
> Are you sure that you have simple recovery model selected for tempdb?
>
> Regards,
> Daniel
>
> "michelle" <michelle@nospam.com> wrote in message
> news:#FjEC4Q6EHA.260@TK2MSFTNGP10.phx.gbl...
> > The server is Windows 2003, SQL Server 2000, sp3 Standard Edition.
> >
> > We have at least two databases on this server in simple recovery model.
Of
> > course, one of these databases is tempdb so this is very problematic.
> >
> > The transaction logs just keep filling up and filling up, growing to
max,
> > and finally become full. We would then have to issue an alter database
> > statement to increase the size of the log. Although an alter database
> > statement is one of those things that should trigger a checkpoint - it
> does
> > not clear out the space used in the log file. So, once we are able to
get
> a
> > bit of free space, we can manually issue a checkpoint.
> >
> > We have incorporated a checkpoint to run every 15 minutes. We also have
an
> > alert that will catch a log at 80% full and then issues a checkpoint on
> that
> > database. But, we want to figure out what is going on and what is
causing
> > this.
> >
> > Any ideas?
> >
> > Michelle
> >
> >
>
>

Relevant Pages

  • Re: Migrating to new hardward
    ... Moving SQL Server databases to a new location with Detach/Attach ... There is a specific section on moving tempdb. ... recreating the clustered index and specifying a filegroup for the new table. ...
    (microsoft.public.sqlserver.setup)
  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... I am looking at databases set to simple: ... > Columnist, SQL Server Professional ... >> She says that she has simple recovery and that one of them is tempdb. ... >> Yes, you are right, I read that Michelle is writing about logs not log, ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction log and tempdb
    ... tempdb in SQL Server and I hop you could help me ... - Is it possible to reduce the size of the transaction log fil during ... It sounds as if you are the database is in full recovery. ... If I execute that script sql server seems ...
    (comp.databases.ms-sqlserver)
  • DB attach error
    ... When we attach one of our databases, sql server shows this error: ... Is there any way to recovery this database. ...
    (microsoft.public.sqlserver.server)
  • Re: Write query to find Recovery Model...
    ... "Brett Davis" wrote in message ... > Is there a query that i can write to find out the recovery models for all ... > then manually going through the databases one by one through Enterprise ... > I am using SQL Server 2000. ...
    (microsoft.public.sqlserver.programming)
Loading