Posted by alwinkotiya on 06/13/06 15:21

I did not get you. Please specify.

Robert Klemme wrote:
> 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

• Next in forum: Re: SQL server backup and truncate log file
• Prev in forum: [ANNOUNCE] Stylus Studio 2006 Release 3 Now Available
• Thread view: Re: SQL server backup and truncate log file

[Reply to this message]