Posted by Erland Sommarskog on 06/13/06 15:21

(alwinkotiya@gmail.com) writes:
> 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????

Wait here. You don't want to truncate the log regularly. Then you can
just as well run with simple recovery model. What you want to do is
to *back up* the transaction log regularly.

The best way to do this is of course to do it from SQL Server Agent. You
can use the interactive dialog in for backup in Enterprise Manager/Mgmt
Studio and schedule the job from these dialogs.

Provided, that is, you are not running SQL 2005 Express which does not
include Agent.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Perfomance Question
• Prev in forum: Re: SQL server backup and truncate log file
• Thread view: Re: SQL server backup and truncate log file

[Reply to this message]