Re: sql 2k log files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Danijel Novak (danijel.novak_at_snt.si)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 21:42:16 +0100

My opinion is that the safest way to truncate a tran log after backup is
using a tran log backup.
Also full backup does NOT truncate the LOG. Acctually there is a check box
in EM; but to be honest, i don't trust that check box to much.

So I would suggest you to use tran log backup.

Danijel

"Bob" <nospam@hotmail.com> wrote in message
news:O6s1MYO%23EHA.3336@TK2MSFTNGP11.phx.gbl...
>
> Right.. so just to clarify, is performing a full backup SUPPOSED to
> truncate the log? If so, is there any reason why my logs arent
> truncating by itself?
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Large transaction log backups
    ... I have a maintenance job set up to back up the transaction ... to delete the older tran log backup file from the previous ... but I'm doing log shipping using a custom script and ...
    (microsoft.public.sqlserver.server)
  • SIMPLE recovery
    ... Recovery model is SIMPLE. ... Tran Log backup during day. ... My understanding is with SIMPLE recovery, it's not possible to restore using ...
    (microsoft.public.sqlserver.server)