Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008

    Unanswered: Transaction Log Question


    My question is I read in the text book that all transactions are held in the transaction log until the transaction log is backup, does this also apply to a full backup?

    So if I do a full backup in a maintenance plan, will all the transaction be still held in the transaction log?

    I am asking this because I am implementing log shipping and was wondering if I will be able to do a full backup of a database that is implemented for log shipping?


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    Full backups do not truncate the transaction log. they do however include the transaction log. Only a log backup will truncate a transaction log.

Posting Permissions

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