471,119 Members | 1,429 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,119 software developers and data experts.

SQL server backup and truncate log file

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????

Plz Help.

Jun 13 '06 #1
3 11670
al*********@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
Jun 13 '06 #2
I did not get you. Please specify.

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


Jun 13 '06 #3
(al*********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 13 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by D. Buck | last post: by
3 posts views Thread by Thiko | last post: by
4 posts views Thread by David Greenberg | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.