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 18:39:33 -0500

Now all we need are the results... 

-- 
   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:u6RXHH66EHA.3368@TK2MSFTNGP10.phx.gbl...
I think so,
also I think next line will go straight.
select name,databasepropertyex(name,'recovery') model from
master.dbo.sysdatabases
Regards,
Daniel
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:OqkKwr06EHA.2488@TK2MSFTNGP14.phx.gbl...
> 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

  • Create indexes - own File Group
    ... on their own logical raid groups. ... My databases are SIMPLE, so they dont use much, if any logs (none as I ... SQL Server 2005 Enterprise x64 SP2 ...
    (comp.databases.ms-sqlserver)
  • 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: Suspect
    ... there has been no activity on these databases so there shouldn't be any records in the tran logs to get unsynced. ... SQL server perform system stuff in the background, so even if you didn't do any operations, there are checkpoint and other things going on. ...
    (microsoft.public.sqlserver.server)
  • Redirect SQL 2005 data & log files to another partition
    ... When SQL Server 2005 was originally installed by previous IT guy he accepted ... Now all new databases and logs will be ... redirecting after installation. ...
    (microsoft.public.sqlserver.setup)
  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
Quantcast