Re: Scheduling a script


"Myth of Sisyphus)." <teller_117@xxxxxxxxxxx> wrote in message
news:5y4Ge.5644$q23.914966@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi Greg,
>
> I do have a log file backup scheduled along with my regular backup.
> However, I do get sporatic log file full messages. I then have to run the
> script through the query analyzer that appears to solve the problem
untill
> the next time.

But then you've completely invalidated your log backup chain.

I think you need to revisit your disaster recovery scenario since once
you've done the truncate, you can no longer recover anything past the last
transaction back up or full backup.

You're either better of doing transaction log backups more often to avoid
filling up your log, making your log larger, or finding out what's filling
them up.


>
> regards
>
> gilbert
>
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@xxxxxxxxxxx> wrote in
message
> news:J5VFe.10184$oZ.2845@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> >
> > "Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx> wrote in message
> > news:42e7ed30$1_1@xxxxxxxxxxxxxxxxxx
> > > Hi
> > >
> > > Look at SQL Server Agent in BOL. It can schedule jobs and run code.
> > >
> >
> > Can I add though that this script is probably not a good idea.
> >
> > Either run the database in simple mode or perform actual log backups.
> >
> >
> > > Regards
> > > --------------------------------
> > > Mike Epprecht, Microsoft SQL Server MVP
> > > Zurich, Switzerland
> > >
> > > IM: mike@xxxxxxxxxxxx
> > >
> > > MVP Program: http://www.microsoft.com/mvp
> > >
> > > Blog: http://www.msmvps.com/epprecht/
> > >
> > > "Myth of Sisyphus)." <teller_117@xxxxxxxxxxx> wrote in message
> > > news:iqRFe.4700$q23.748061@xxxxxxxxxxxxxxxxxxxxxxxx
> > > >I wish to run this script daily. Can this be scheduled?
> > > >
> > > >
> > > > backup log shipmateDB with truncate_only
> > > >
> > > >
> > > > G
> > > >
> > > >
> > >
> > >
> >
> >
>
>


.

Relevant Pages

  • Re: Unable to attach the database
    ... BUT NEVER DELETE A LOG FILE! ... If you have a clean backup of the database, ... good understanding of SQL Server and how to work from this situation. ...
    (comp.databases.ms-sqlserver)
  • Re: Transaction Log Failure
    ... A maintenance plan can not create a log file, ... then bring up sql server. ... > maintenance plan that would create a transaction log file every hour. ... > 2004-12-14 21:00:43.51 backup BACKUP failed to complete the command ...
    (microsoft.public.sqlserver.server)
  • Re: suitable plan for Log backup
    ... transactions since the last log backup... ... To reduce the risk backup the log ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... after backup the size of log file does not decrease. ...
    (microsoft.public.sqlserver.server)
  • RE: Error with SBS backup
    ... Error 800423f4 appears in the backup log file when you back up a volume by ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server Transaction Log
    ... BACKUP LOG databasename WITH TRUNCATE_ONLY ... SQL Server MVP ... > truncate_only option but no change in the log file size. ...
    (microsoft.public.sqlserver.server)