Posted by Robert Klemme on 06/13/06 13:08

alwinkotiya@gmail.com wrote:
> Hi all,
>
> If I set recovery model SIMPLE then truncation of log files will be
> automated , but I will lose
> database changes made since the last backup was taken.
> Is there any way to automate truncation of log file and
> backup of database upto last change has been done????

Maintenance plan.

robert

[Back to original message]