• HanShi (7/17/2013)


    I agree that it won't break your LOG chain, maybe I used the wrong words to explain my statement well. I assumed the OP was referring to how to restore when a unexpected backup was taken (and backup file not available). Therefor I also tried to describe an example.

    Except that the example has nothing to do with the LSN chains that the OP asked (full backups reset the differential base, that's all)

    A log chain can only be broken by changing the recovery model to simple and back to full or bulk-logged.

    It can be broken by a number of other things than just that, but full backups are not one.

    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