Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: Backup striping to multiple devices

    Hello--

    I am trying to backup a VLDB (800+gig) to multiple devices. I am using 4 disk drives. Assuming all devices have the same performance, should the 4 devices fill equally? (IE 200gig per drive) If so, what would might happen if one of the 4 drives only has 100 gig free with the other 3 having 300 gig free each?

    Thanks for the help--
    Jeff

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There are 10,000 moving pieces in this puzzle... If you define the four disks as one logical drive using RAID, you have no way to tell and no reason to care. If you define the four disks as four physical drives, you can specify what goes on which drive, and tinker to your heart's content.

    I would STRONGLY suggest using RAID, and letting the hardware/OS do its job. Device management is an incredibly poor use of a dba's time in almost every case I can imagine.

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    When performing striped backup SQL "pre-estimates" each device size, but fills them up sequentially. Any activity on the database while the backup is running also affects the final size.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •