Re: Newbie Question on DB Maintenance Plan

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@xxxxxxxxx) 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@xxxxxxxxxxxxx

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

.

Relevant Pages

  • Re: Log Shipping: question about secondary dB mode?
    ... Regular transaction log backups will allow the committed and backed up portion of the log file to be reused for new transactions. ... And last to recover the db you restore the last log file using the WITH RECOVERY option and you should be all set. ... all the backup and restore jobs are proceeding without errors. ...
    (microsoft.public.sqlserver.tools)
  • Re: How can I back up a log-shipped database?
    ... This means that a later log backup from the production database will not just be ... able to add the log records to the log-shipped database, because the transaction log has been ... It's clear I don't understand the whole RECOVERY business. ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction Log Size
    ... listed in my article has detailed info on shrinking of the transaction log. ... Tibor Karaszi, SQL Server MVP ... > (database + transaction log) with fake appended to the name. ... >> CommVault to backup the backup files. ...
    (microsoft.public.sqlserver.server)
  • Re: 1105 - log file getting full - SQL Server 6.5
    ... Follow Hari's instructions, backup the transaction log on a regular basis, ... Wayne Snyder, MCDBA, SQL Server MVP ... > Can't allocate space for object 'Syslogs' in database ''corp'' because ...
    (microsoft.public.sqlserver.server)
  • Re: HDD still full after shrinking transaction log
    ... So that is the first question: why does the log keep growing? ... In the first case, you should run with full recovery, and backup your ... SQL Server will then truncate the transaction log regularly. ...
    (comp.databases.ms-sqlserver)