Post reply

COPY ONLY Backups - What Impact Do They Have On Perfomance

  • May 16, 2012 at 9:06 am

    #145249

    I realize this may be to much of a "It Depends" type of question and answer scenario but does anyone know, preferably from experience, if performing a COPY ONLY backup of their DB while its live/In Use has an impact of such that the users work in the DB is affected enough to warrant not doing a COPY ONLY while the DB is in use?

    We are having some problems (once again) with our Microsoft DPM Backup System and I want to make a COPY ONLY backup right away so that I have a somewhat recent recovery point but I can’t find any documentation on what kind of impact if any a COPY ONLY backup has on the DB if its in use.

    Thoughts?

    Thanks

    Kindest Regards,

    Just say No to Facebook!

  • May 16, 2012 at 9:13 am

    #1488473

    You are correct, it depends. I have run both full backups and copy only full backups on databases during the day with no apparent impact on the users (or at least they never complained). The only thing to remember is that a copy only backup cannot be used as a base for a point in time recovery. It is a snapshot of the database a that time.

  • May 16, 2012 at 10:02 am

    #1488526

    Ditto with Lynn's experience. Works fine, same as a regular backup.

  • May 16, 2012 at 10:20 am

    #1488542

    Thanks, thats just what I needed dto know.

    Kindest Regards,

    Just say No to Facebook!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply