Posted by Greg D. Moore \(Strider\) on 09/20/06 11:21

"DataPro" <datapro01@yahoo.com> wrote in message
news:1158252255.146201.93870@h48g2000cwc.googlegroups.com...
> 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?
>

Because you may want to run that at separate times.

For example, I do a full backup 3 nights a week and transaction log backups
every 20 minutes.

> In a db designated full recovery mode wouldn't that be automatic when
> taking a backup?

No.


>
> Thanks in advance.
>
> Gerry
>

• Next in forum: Re: Newbie Question on DB Maintenance Plan
• Prev in forum: Re: DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'
• Thread view: Re: Newbie Question on DB Maintenance Plan

[Reply to this message]