Re: Scheduling a script
- From: "Myth of Sisyphus\)." <teller_117@xxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 08:51:11 -0400
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.
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
> > >
> > >
> >
> >
>
>
.
- Follow-Ups:
- Re: Scheduling a script
- From: Greg D. Moore \(Strider\)
- Re: Scheduling a script
- References:
- Scheduling a script
- From: Myth of Sisyphus\).
- Re: Scheduling a script
- From: Mike Epprecht \(SQL MVP\)
- Re: Scheduling a script
- From: Greg D. Moore \(Strider\)
- Scheduling a script
- Prev by Date: 2006-07-26 00:00:00
- Next by Date: Re: 2006-07-26 00:00:00
- Previous by thread: Re: Scheduling a script
- Next by thread: Re: Scheduling a script
- Index(es):
Relevant Pages
|
