Posted by Ed Murphy on 09/14/06 17:01

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?

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

• Next in forum: Re: Newbie Question on DB Maintenance Plan
• Prev in forum: Excel Inserts Null Values in DTS package
• Thread view: Re: Newbie Question on DB Maintenance Plan

[Reply to this message]