Posted by Erland Sommarskog on 09/14/06 21:32

DataPro (datapro01@yahoo.com) writes:
> If a database is set to full recovery mode, and in setting up a
> database maintenance plan you specify a database backup, why in the
> wizard is the question asked if you want to back up the transaction
> log?
>
> In a db designated full recovery mode wouldn't that be automatic when
> taking a backup?

No, you back up the transaction log independetly from the database.
It's a common mistake to run in full recovery but fail to take
transaction log backup. This leads to that the log keeps growing.

On the other hand, if you run simple recovery, you get forget all
about the transaction log.


--
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: Re: Can I avoid temp tables, etc.
• Prev in forum: Re: sql 2005 client tools
• Thread view: Re: Newbie Question on DB Maintenance Plan

[Reply to this message]