Posted by Greg D. Moore \(Strider\) on 10/01/65 11:22

"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
> >
> >
>
>

[Back to original message]