backup/master: strategies for archiving dianne mcadam senior analyst and partner data mobility group
TRANSCRIPT
![Page 1: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/1.jpg)
BACKUP/MASTER:Strategies for Archiving
Dianne McAdamSenior Analyst and PartnerData Mobility Group
![Page 2: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/2.jpg)
Backup versus archiving
Terms used interchangeably
Define different processes
Different end results
![Page 3: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/3.jpg)
Backups
Designed to protect ALL data
• Datacenter, desktop, laptops
Run on a regular basis
• Every 24 hours
• More often for mission-critical applications
Multiple backup copies are saved
• Several copies of weekly backups
• Incrementals
• Monthly and quarterly backups
![Page 4: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/4.jpg)
Backups (2)
Usually not actively deleted
Overwritten
• Second set of incrementals overwrites the first
• Fifth set of weekly backups overwrites the first
Multiple backup processes and software
can exist
• One product for laptops
• Another for departmental backups
![Page 5: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/5.jpg)
Archive
Not a backup copy
Not a disaster recovery copy
Data that is kept for a long period of time
Can be called:
• Fixed-content data
• Unstructured data
• Reference data
• Retention managed data
![Page 6: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/6.jpg)
Archive (2)
Active archive
Deep archive
![Page 7: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/7.jpg)
Active archive
Software to “slim down” databases
Databases expand over time
Customer databases contain numerous
“inactive” customers
Software extracts inactive data
• Associated table definitions, indexes, metadata
Migrates inactive data to lower-cost storage
• Disk, tape or optical storage
![Page 8: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/8.jpg)
Active archive (2)Designed to improve management of large
databases
Not a replacement for backup
Not a form of data protection
Does not have to run daily, but on a regular basis
• Weekly, monthly
• Depends on the amount of data that becomes “inactive”
Saves money
• Using lower-cost storage
Improves performance of main database
• Quicker to backup and restore
![Page 9: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/9.jpg)
Deep archiving
Corporations have had internal policies for how
long data should be kept
• Medical, financial, employee records
• Engineering designs
New regulations are dictating retention periods
Archival software designed to store regulated
and non-regulated data for specific period of
time
![Page 10: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/10.jpg)
Deep archiving (2)
Not a backup copy
Not a disaster recovery copy
Data is actively deleted
• When a specified time period elapses
Seven years for e-mail
• When a specific event occurs
Two years after an employee leaves the company
![Page 11: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/11.jpg)
Deep archiving (3)
Many different types of storage
• Tape, optical, disk, special appliances
Backups store multiple copies of data;
archive should store only one copy
SEC 17a-4
• Need to keep one copy offsite
Some regulations require WORM support
![Page 12: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/12.jpg)
Deep archiving (4)
Recovery Time Objectives (RTO)
• Time to recover data
• Different from backups
Recovery Point Objectives (RPO)
• Age of data used to restore
• RPO = 0
![Page 13: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/13.jpg)
What’s the cost?
Not just acquisition costs
Other long-term costs
• Environmental factors
• Maintenance
![Page 14: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/14.jpg)
Hardware requirements
How much data will be archived?
• Projected growth rate
• Retention period
• Backed up onsite or offsite
• Extra capacity for unexpected growth
![Page 15: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/15.jpg)
Hardware requirements (2)
Media choice
• Disk, SATA disk, tape, optical
Average disk/tape utilization
RAID level
• Combination of disk/tape?
• WORM support required?
![Page 16: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/16.jpg)
Purchase and maintenance costs
Purchase price
Installation and freight charges
Warranty period
Lifespan of equipment
Cost to migrate
• People
• Software
![Page 17: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/17.jpg)
Software requirements
Archive software costs
Additional software required?
Compatibility with existing/new
equipment
![Page 18: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/18.jpg)
Environmental requirements
Footprint
Power
Cooling
![Page 19: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/19.jpg)
Calculating the costs
Calculate storage requirements
Assumptions
• Initial storage requirements = 50 TB
• Annual growth rate = 10%
• Average tape utilization = 85% Average compression 2:1
• Average disk utilization = 70%
• No data expires the first 7 years
![Page 20: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/20.jpg)
Calculating the costsTerabytes Year
1
Year
2
Year
3
Year
4
Year
5
Year
6
Year
7
Initial
Storage
50 55 60.5 66.6 73.3 80.6 88.7
New Data 5 5.5 6.1 6.7 7.3 8.1 8.9
Total Data 55 60.5 66.6 73.3 80.6 88.7 97.6
Disk
Requirements
78.6 86.4 95.1 104.7 115.1 126.7 139.4
Tape
Requirements
64.7 71.2 78.4 86.2 94.8 104.4 114.8
![Page 21: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/21.jpg)
All-tape configuration
Tape Library $77,860
4 LTO2 Drives $73,560
287 Cartridges $18,655
Total $170,075
![Page 22: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/22.jpg)
All-disk configuration
10 controllers $243,810
30 expansion units $695,490
4 racks $18,000
Total $957,300
![Page 23: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/23.jpg)
Calculating environmentalsAssumptions
• $20/square foot/month
• $.10/KWH
• Electrical = (Power + cooling) * units *
8760 *.1
Footprint Yearly
Cost
Power
per unit
Cooling
per unit
Electrical
per year
Total
Library 10.2 $2448 .92 KWH .92 KWH $1612
Drives 0 $0 .032
KWH
.032
KWH
$ 224
Total $1836 $4284
![Page 24: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/24.jpg)
Calculating environmentals (2)Assumptions
• $20/square foot/month
• $.10/KWH
• Electrical = (Power + cooling) * units *
8760 *.1
Footprint Yearly
Cost
Power
per unit
Cooling
per unit
Electrical
per year
Total
Disk Base
unit
29 $6,940 .33 KWH .39KWH $6,307
Expansion
unit
0 $0 .33 KWH .39 KWH $18,921
Total $25,228 $32,168
![Page 25: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/25.jpg)
Seven-year costsYear 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Total
Tape $174,359 $4,284 $4,284 $4,284 $4,284 $4,284 $4,284 $200,063
Disk $989,468 $32,168 $32,168 $32,168 $32,168 $32,168 $32,168 $1,182,476
![Page 26: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/26.jpg)
Some caveats – not included
The cost of maintenance
The cost to replace disk and tape
The cost of the software
The cost of phasing in equipment
purchases
![Page 27: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/27.jpg)
Some caveats – not included (2)
The amount of data that will expire
The cost associated with backing up data
The additional cost for RAID-1 or RAID-5
disk
The additional cost of HBAs and cables,
etc.
![Page 28: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/28.jpg)
Other optionsHybrid disk/tape solution
Raw Usable
Disk Capacity 24.5 17.2
Tape Capacity 95 80.8
Total 120 98
![Page 29: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/29.jpg)
Hardware costs - hybridDisk appliance
$276,600
Tape
Library
$76,640
2 LTO2
drives
$36,780
238 cartridges
$15,470
Total $128,890
![Page 30: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/30.jpg)
Seven-year costs: Hybrid solution
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Total
Tape $133,062 $4,172 $4,172 $4,172 $4,172 $4,172 $4,172 $158,094
Disk $284,285 $7,685 $7,685 $7,685 $7,685 $7,685 $7,685 $330,395
Total $488,489
![Page 31: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/31.jpg)
Summary
Disk
• Initially costs more and continues to cost more over
the years
• Faster retrieval time
• How often do you replace disk?
Every 3 years?
Tape
• Initially costs less and continues to cost less
• Slower retrieval time than disk
• How often do you replace tape?
Every 5 – 7 years?
![Page 32: BACKUP/MASTER: Strategies for Archiving Dianne McAdam Senior Analyst and Partner Data Mobility Group](https://reader035.vdocuments.us/reader035/viewer/2022070401/56649f1d5503460f94c3488e/html5/thumbnails/32.jpg)
Summary (2)
WORM support
• WORM cartridges cost 10-15% more
Evaluate tape/disk combination
• Evaluate integrated tape with disk appliance
Evaluate migration efforts and costs