Posted by DataPro on 09/14/06 16:44

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?

Thanks in advance.

Gerry

• Next in forum: Re: SQL Server training
• Prev in forum: Re: stored proc bug with datetime variable
• Thread view: Newbie Question on DB Maintenance Plan

[Reply to this message]