Posted by DataPro on 09/15/06 11:55

Yes I was able to finally glean that from looking through a number of
manuals. Makes sense......I guess it also makes sense not to assume
anything about SQL Server :)

Thanks much for the help.

Gerry


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

• Next in forum: Re: Line Break in T-SQL
• Prev in forum: Re: Synchronizing Access and SQL Server
• Thread view: Re: Newbie Question on DB Maintenance Plan

[Reply to this message]