Home Forums SQL Server 2005 Backups Multiple backup at the same time RE: Multiple backup at the same time

  • March 7, 2014 at 4:13 pm

    #1695274

    Jack Corbett (3/7/2014)

    I would question why you'd want to run them in parallel if you are writing them all to the same drive, especially if all the databases are located on the same drive. You are adding extra IO Load to the whole system. I'd be more inclined to let them run sequentially to spread the IO load out over time. I might consider running them in parallel if I was writing each backup to separate locations.

    +1000. Under the conditions you mention, it very well could be that the parallel backups might actually run slower than the sequential backups. At the very least, it's going to drive the R/W heads on the disks nuts.

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