• UMG Developer (3/23/2011)


    Can the third party backup tool be configured to make the backup in "copy only" mode? (That should prevent the LSN from being changed and breaking the backup chain.)

    Not unless it's log backups that the 3rd party tool is taking. Full backups do not break the log chain.

    http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/

    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