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 17, 2013 at 6:23 am

    #1633217

    HanShi (7/17/2013)

    Any full backup will break the LSN chain, unless it's executed with the COPY_ONLY option. But this breaking of the LSN chain only applies to the DIFF backups. If you have all the LOG backups available since 2 or 3 FULL backups before, you can still use this to restore to the current point-in-time.

    I beg to differ with you. Full and Differential backups WILL NOT break your log chains.