|
|
Posted by Myth of Sisyphus\). on 10/01/71 11:22
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@greenms.com> wrote in message
news:J5VFe.10184$oZ.2845@newsread2.news.atl.earthlink.net...
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:42e7ed30$1_1@news.bluewin.ch...
> > 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@epprecht.net
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> > "Myth of Sisyphus)." <teller_117@hotmail.com> wrote in message
> > news:iqRFe.4700$q23.748061@news20.bellglobal.com...
> > >I wish to run this script daily. Can this be scheduled?
> > >
> > >
> > > backup log shipmateDB with truncate_only
> > >
> > >
> > > G
> > >
> > >
> >
> >
>
>
Navigation:
[Reply to this message]
|