Re: Scheduling a script


"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: Scheduling a script
    ... It can schedule jobs and run code. ... Mike Epprecht, Microsoft SQL Server MVP ... MVP Program: http://www.microsoft.com/mvp ...
    (comp.databases.ms-sqlserver)
  • Re: sp_helptext and long SP
    ... SQL Server MVP ... > I can't use the manual script since I need to generate a script of all> my ... start coding your scripts outside of the database and store ...
    (microsoft.public.sqlserver.server)
  • Re: Not In and Not Exists
    ... The comments in the script should be ... SQL Server MVP ... >> INSERT INTO Table2 VALUES ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Generate Scripts...
    ... Aaron Bertrand [SQL Server MVP] writes: ... job that runs the same script. ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Last Modified Date of table, queries, views, sprocs
    ... Aaron Bertrand [SQL Server MVP] writes: ... e.g. if you add indexes, change column datatypes, etc. ... A new CREATE TABLE script? ...
    (microsoft.public.sqlserver.tools)