Copy of 1 TB prod database

• Jeff Moden

  SSC Guru

  Points: 1004402

  More actions

  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)