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 5:47 am

    #1633191

    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.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **