Re: Checkpointing Not Happening in Simple Recovery Model

From: Daniel Joskovski (omnis_at_NOSPAMunetREMOVECAPS.com.mk)
Date: 12/26/04 

Date: Sun, 26 Dec 2004 02:05:48 +0100

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: Question about Exchange Logs and DBs Best Practice
    ... Yes, even from 5.5 days, the primary reason you separate logs from databases ... For Exchange news, links and tips, check: ... > If you put ALL the databases in one RAID set, then if that one RAID set ...
    (microsoft.public.exchange2000.admin)
  • Re: Disk Partitioning/RAID recommendations
    ... Probably the best thing you can do is to separate the databases and logs ... However, you may be tight for space on the mirror this way, so you could ... Repartitioning drives as we move from Exchange 2000 to ...
    (microsoft.public.exchange2000.setup.installation)
  • Re: E2K7 SP1 Configuring Storage
    ... So any info you can provide on how NetApp has their databases or storage ... One Volume has one LUN in it and one database inside that LUN. ... Put the SNAPINFO on the same LUN as the transaction logs. ... talk to NetApp about your aggregates. ...
    (microsoft.public.exchange.setup)
  • Re: Transaction logs not being purged
    ... databases aren't being purged after the backup. ... The transaction logs ARE being purged on the other 4 databases. ...
    (microsoft.public.exchange.admin)
  • Re: cant mount the database error
    ... => First of all Don't worry about Event Service. ... Missing logs is most likely the cause of your current problem. ... Restated the server and all> exchange services are up and running > but my databases are not mounted. ... > also, when we checked the integrity,we got a warning> message that the database is not up to date and need to> use the recovery option. ...
    (microsoft.public.exchange2000.information.store)