Wednesday, April 18, 2007

Maths lesson

Following on from the SQL 2005 entry...

 

Main corporate database 50GB, TLs 43GB (verbose logging), Indexes 25GB. Backup to disk using ordinary SQL server 22GB.

Litespeed backup to disk 7GB.

Other databases TBC but will be more than zero.

Data retention 85 days (see http://nickgillott.blogspot.com/2006/10/backup-strategy.html) means a saving of 15GB per day for 85 days or 1.3TB of space off the RAID array.

 

To put it another way, uncompressed I need 2TB of RAID array and £300 worth of tapes per job (17 jobs in a cycle). Compressed I need 700GB of RAID array and £120 worth of tapes per job.

 

£180 per job saving for 17 jobs per cycle is not chicken feed folks. In fact, the savings in backup tapes more than pays for the software. We also save on the RAID array requirements, the time taken to backup to disk, the time taken to backup to tape, the tape storage in our offsite bunker...

 

 

No comments: