Home Forums SQL Server 2005 Backups Create a policy to avoid backups withou copy_only option RE: Create a policy to avoid backups withou copy_only option

  • December 12, 2012 at 1:58 am

    #1567751

    Hemant.R (12/12/2012)

    hi ,

    you can used copy_only option to take full backup. when transaction log backup job created for same database .

    bcoz it will not break lsn squence of database .

    Full backups never break the log chain (LSN sequence), no matter what options are specified.

    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