Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: truncate log and full backup?

    When we do a full backup " backup database dbname to xxxx"

    will the transaction log got truncated as well? if that is the case, how
    can I fingure out the minLSN number for current log.

    Or only when we use" backup log dbname with truncate_only' we can get the log truncated and immediate following a full backup to make the system safe??

    Thanks for you answer.


  2. #2
    Join Date
    Aug 2002
    BOL refers In the full and bulk-logged recovery models, a sequence of transaction log backups is being maintained. The part of the logical log before the MinLSN cannot be truncated until those log records have been copied to a log backup.

    If backing up the log does not appear to truncate most of the log, an old open transaction may exist in the log. Log space can be monitored with DBCC SQLPERF (LOGSPACE).

    After backing up the log using either NO_LOG or TRUNCATE_ONLY, the changes recorded in the log are not recoverable. For recovery purposes, immediately execute BACKUP DATABASE for safe recovery.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts