Home Forums SQL Server 2008 SQL Server 2008 Administration Full backups on any database, will it affect the LSN chain ? RE: Full backups on any database, will it affect the LSN chain ?

  • July 19, 2013 at 11:51 am

    #1634139

    kevaburg (7/19/2013)

    mohan.bndr (7/17/2013)

    Hi All,

    Have one situation...

    If we take full backup .. will it be affect the LSN Chain. Please reply me

    No. Only a transaction log backup will break the chain.

    Actually, no. A transaction log backup does not break the chain. The chain can be broken, however, if a transaction log backup becomes corrupt or lost.