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:37 pm

    #1761348

    slimchance99 (11/27/2014)

    The reason is that the daily copy-only backups are performed at the data centre onto their backup media as part of the enterprise DR plan. If we have to perform a PIT restore using those it is a major hassle, as we have to contact the data centre and have them restore the files from their media for us to access. For local use we prefer to keep our own separate backup plans so we do not have to go through that aggravation, delay and expense.

    OK. NP. What is the data center using to do the backups with? SQL Server or something else?

    Also, how big is the weekly FULL backup and how big are the DIF backups throughout the week

    --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)