Re: Checkpointing Not Happening in Simple Recovery Model
From: Daniel Joskovski (omnis_at_NOSPAMunetREMOVECAPS.com.mk)
Date: 12/26/04
- Next message: Tom Moreau: "Re: Checkpointing Not Happening in Simple Recovery Model"
- Previous message: Hugo Kornelis: "Re: Tree questions about DATETIME"
- In reply to: Tom Moreau: "Re: Checkpointing Not Happening in Simple Recovery Model"
- Next in thread: Tom Moreau: "Re: Checkpointing Not Happening in Simple Recovery Model"
- Reply: Tom Moreau: "Re: Checkpointing Not Happening in Simple Recovery Model"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Dec 2004 00:24:15 +0100
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
> > >
> > >
> >
> >
>
>
- Next message: Tom Moreau: "Re: Checkpointing Not Happening in Simple Recovery Model"
- Previous message: Hugo Kornelis: "Re: Tree questions about DATETIME"
- In reply to: Tom Moreau: "Re: Checkpointing Not Happening in Simple Recovery Model"
- Next in thread: Tom Moreau: "Re: Checkpointing Not Happening in Simple Recovery Model"
- Reply: Tom Moreau: "Re: Checkpointing Not Happening in Simple Recovery Model"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
