Home Forums SQL Server 2014 Administration - SQL Server 2014 Point in time restores referencing copy-only backups? RE: Point in time restores referencing copy-only backups?

  • November 27, 2014 at 1:08 pm

    #1761344

    slimchance99 (11/25/2014)

    On one of our SQL Server 2014 boxes each database has a copy-only full backup made every night, in addition to the maintenance plan schedule of a full backup weekly, daily differential backups and log backups.

    That would be the problem. You're taking the daily full backups anyway. Why not make them useful by making them NOT copy only and stop doing the daily DIFs altogether? It's not like those daily DIFs are actually saving you any disk space or making PIT restores any easier. In fact, they're just making things more complicated than necessary.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)