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

    Unanswered: Transaction Log Question

    Hi,

    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?

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    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
  •