Home Forums SQL Server 2008 SQL Server Newbies Copy of 1 TB prod database RE: Copy of 1 TB prod database

  • November 21, 2015 at 5:12 pm

    #1841538

    tripleAxe (11/18/2015)

    In my experience backup time was significantly reduced. I had a 1TB database that was taking 5 hours to backup. Changed the backup to stripe to 8 files and the backup time reduced to 1 and a half hours. I can't remember what difference it made to the restore time. This was quite a few years ago.

    "It Depends". On several systems, I've seen striping the backups slow things down quite a bit because they striped them all to the same drive, which also turned out to be the same "spindle". Drove the R/W heads nuts.

    Striping to different spindles? Now THAT's a different story. It's just very difficult to do that on a SAN because it seems that a lot of SAN operators have forgotten how to spell "spindle".

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