how to set a schedule to run codes like

backup log <dbname> with truncate_only
thanks
benExpand SQL Server Agent, create a new job, add a job step with that code. However, the question is
why you want to execute that command regularly? If you don't do log backup, set the database to
simple recovery model.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<libin918@.gmail.com> wrote in message news:1149613568.316745.80160@.g10g2000cwb.googlegroups.com...
> backup log <dbname> with truncate_only
> thanks
> ben
>|||Thanks Tibor.
Yes. we can setup to simple model. But the thing is we want a full
model and meanwhile we dont want them to grow up too big. it doesnt
make a sense? :)
Thanks again
Tibor Karaszi wrote:
> Expand SQL Server Agent, create a new job, add a job step with that code. However, the question is
> why you want to execute that command regularly? If you don't do log backup, set the database to
> simple recovery model.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <libin918@.gmail.com> wrote in message news:1149613568.316745.80160@.g10g2000cwb.googlegroups.com...
> > backup log <dbname> with truncate_only
> >
> > thanks
> >
> > ben
> >|||If you are in full model, then the log is emptied every time you backup the transaction log. So
adding backup log with truncate_only will not add anything to that backup strategy, it will only
break the log backup sequence. Are you doing regular log backups? How often?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<libin918@.gmail.com> wrote in message news:1149686820.193242.3960@.y43g2000cwc.googlegroups.com...
> Thanks Tibor.
> Yes. we can setup to simple model. But the thing is we want a full
> model and meanwhile we dont want them to grow up too big. it doesnt
> make a sense? :)
> Thanks again
> Tibor Karaszi wrote:
>> Expand SQL Server Agent, create a new job, add a job step with that code. However, the question
>> is
>> why you want to execute that command regularly? If you don't do log backup, set the database to
>> simple recovery model.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> <libin918@.gmail.com> wrote in message
>> news:1149613568.316745.80160@.g10g2000cwb.googlegroups.com...
>> > backup log <dbname> with truncate_only
>> >
>> > thanks
>> >
>> > ben
>> >
>

how to set a schedule to run codes like

backup log <dbname> with truncate_only
thanks
benExpand SQL Server Agent, create a new job, add a job step with that code. Ho
wever, the question is
why you want to execute that command regularly? If you don't do log backup,
set the database to
simple recovery model.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<libin918@.gmail.com> wrote in message news:1149613568.316745.80160@.g10g2000cwb.googlegroups.
com...
> backup log <dbname> with truncate_only
> thanks
> ben
>