Newbie Question on DB Maintenance Plan

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

.

Relevant Pages

  • Re: error 823, severity 24, state2
    ... Restore damaged files from the latest database backup. ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: Trans. log backup wont execute
    ... You can't do log backup on a database in simple recovery mode. ... >>> in the job history or in the SQL Server Logs. ...
    (microsoft.public.sqlserver.server)
  • Re: How To Protect Backup being restoted in any others from other serv
    ... The only "security" feature provided by SQL Server is password. ... Use other means to protect the file (physical security, network security, EFS ... We have a Database backup taken in SQLServer 2000. ...
    (microsoft.public.sqlserver.server)
  • Re: Database sizes explanation Please?
    ... Is there some where that I can read about this "FUll Recovery mode" and how ... > and good luck Ian... ... > Wayne Snyder, MCDBA, SQL Server MVP ... >> would consider my self to be really new to this Database. ...
    (microsoft.public.sqlserver.server)
  • Re: Database sizes explanation Please?
    ... Is there some where that I can read about this "FUll Recovery mode" and how ... > and good luck Ian... ... > Wayne Snyder, MCDBA, SQL Server MVP ... >> would consider my self to be really new to this Database. ...
    (microsoft.public.sqlserver.programming)