>
> I guess the wizard doesn't force you to use the options sensibly. :)

DataPro wrote:

> New to SQL Server. Running SQL Server 2000.
>
> 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?

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

Erland Sommarskog wrote:
> 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