FULL Recovery mode changed to BULK LOGGED does that break the t-log chain?

  • Should be a quick question I hope. I've forgotten the answer. If you change a 2005 database from FULL to BULK-LOGGED recovery mode when you do your Index rebuilding and then change it back to FULL, doesn't that break the T-Log backup chain?

    Thanks,

    Lezza

  • No - changing from FULL to BULK-LOGGED and back again does not break the log chain. Changing to/from SIMPLE breaks the log chain.

    See the article I link to in my signature for more information on how to manage your transaction logs.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • If I change from full to bulk logged on replicated database (published), rebuild the indexes and change back to full.

    Will it impact replication? Should I stop any of the agents before it?

    I need to do it because of tran. log disk becomes full. BTW I am using SQL 2000 SP3.

  • Replication does not depend in any way on recovery model.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I will be loading several thousand records. If I temporarily change my recovery model from FULL to BULK LOGGED, will I lose the ability to recover to a point in time?

    This link seems to indicate that.

    KU

  • Yes, but just within the log backup interval that contains the bulk operations.

    p.s. Please post new questions in a new thread in future. Thanks

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Will do...Thanks Gail!

    KU

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply