Home Forums SQL Server 2012 SQL 2012 - General Always on Secondry database backup plan & Recovering. RE: Always on Secondry database backup plan & Recovering.

  • June 3, 2014 at 10:28 am

    #1718595

    Faisal Malik (6/3/2014)

    You can't use copy_only backup in point in time recovery.

    The only thing you can't do with a copy-only is restore differentials onto it. You can restore log backups onto it for point-in-time recovery.

    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