Compaq ProLiant 1000 Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 60

requirements, 6 drives would be the safer choice.

Get Compaq ProLiant 1000 PDF manuals and user guides View all Compaq ProLiant 1000 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 60 highlights

Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 60 Note that the MIS manager has decided it is acceptable to restart or possibly lose backup jobs if a tape drive/cassette fails, and so ARCserve and its RAID option - along with their added costs - were not considered. Let's say that fault tolerance had been required: then an ARCserve RAID-5 array would most likely be implemented, and this could affect the choice in hardware. With RAID-5 a minimum of three (3) 35/70 DLT's would be required, providing 70 GB of capacity at just above 30 GB/hr. However, could achieve slightly greater capacity and performance with 6 of the 15/30-GB DLT drives, and at slightly less cost. Even five (5) 15/30 drives in RAID-5 might be sufficient for the job, with 60 GB of capacity (the data would need to compress 25%) at close to 20 GB/hr. However, because they want to allow for growth in the database size (which could increase both capacity and performance requirements), 6 drives would be the safer choice. Finally, if the department had the entire night (say about 8 hours) to perform the database backup, then the DLT 15-Cartridge Library along with ARCserve (and its autochanger support) may have provided a better solution, allowing for unattended backups with even more capacity so that the data could be archived more frequently if needed. Backup to the tape library could also be done across a 100-BaseT network without affecting the completion time (performance would be about the same as doing it locally).

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
Compaq Backup and Recovery for Microsoft SQL Server 6.x
Page
60
Note that the MIS manager has decided it is acceptable to restart or possibly lose backup jobs if a tape
drive/cassette fails, and so ARCserve and its RAID option - along with their added costs - were not
considered.
Let’s say that fault tolerance had been required: then an ARCserve RAID-5 array would
most likely be implemented, and this could affect the choice in hardware.
With RAID-5 a minimum of
three (3) 35/70 DLT’s would be required, providing 70 GB of capacity at just above 30 GB/hr.
However, could achieve slightly greater capacity and performance with 6 of the 15/30-GB DLT drives,
and at slightly less cost.
Even five (5) 15/30 drives in RAID-5 might be sufficient for the job, with 60
GB of capacity (the data would need to compress 25%) at close to 20 GB/hr.
However, because they
want to allow for growth in the database size (which could increase both capacity and performance
requirements), 6 drives would be the safer choice.
Finally, if the department had the entire night (say about 8 hours) to perform the database backup, then
the DLT 15-Cartridge Library along with ARCserve (and its autochanger support) may have provided a
better solution, allowing for unattended backups with even more capacity so that the data could be
archived more frequently if needed.
Backup to the tape library could also be done across a 100-BaseT
network without affecting the completion time (performance would be about the same as doing it
locally).