Solved

Compression Ratio with Backup Exec

Posted on 2004-10-14
9
890 Views
Last Modified: 2013-12-01
I am running Backup Exec 9.1 on a PIV, 1.5 GHz, 512 MB RAM. I am backing up about 14.0 GB of data. Tape drive is a Seagate 20/40. Tapes I am currently using are 12/24. The compression ratio I am getting is 1.08:1, which in my opinion, sucks! I am backing up 13.3 GB on 1st tape, and 700 MB on 2nd tape.

I am currently trying to test whether Hardware or Software compress gives me a better rate, but I was told that because our files are CAD files primarily, compression on the drive won't help much. Is this true? Any ideas?

I do daily backups, so I would hate to have to use 2 tapes per day, so if the compression ratio is average for CAD files, I guess going to a 20/40 tape. Once I get over 20 GB, it's time to change drives??? Thanks.

James
0
Comment
Question by:stressbuny
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 12309573
Compression depends entirely on the file type.  Database files tend to compress greatly.  JPGs and MPGs compress VERY poorly.  Further, to maintain throughput, systems will not do HIGH compression, but rather fast compression.  Take a few of your CAD files and zip them.  What's the compression ratio?  If it's 1.25:1, I'd expect around 1.1-1.15:1 through tape compression.

I NEVER plan my backup system around advertised compression rates.  It's just a bad idea for the reasons you're experiencing.  I use to back up a VARIETY of files - 600 GB - and I got about 125-135 GB per 110 native/220 compressed SDLT tape drive.  IGNORE advertised compression unless you're backing up a database.

0
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 12309583
DLT or better still SDLT holds much more data.  LTO as well.  Current formats of LTO and SDLT hold at least 160GB of data per tape.  Over the long run, depending on your backup scheme, these tend to be more efficient, effective solutions.

What's your backup plan like?  Fulls and Differentials?
0
 

Author Comment

by:stressbuny
ID: 12309621
I checked several CAD files, and my compression ratio on those files is about 1.3125:1, so I guess this my issue, I appear to be hitting the upper threshold of what the software/hardware can compress based on file types. I also have a good amount of JPG and TIF files, as well as long file names.

I guess as a rule of thumb, with my file types, I should not assume compression is going to help at all, and base my backup solution on this.
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 

Author Comment

by:stressbuny
ID: 12309645
My schedule is:

Full backups M-F, running at night. I keep every Thursday tape (earmarked as a Weekly Backup) for 4 weeks. Every month I do a monthly full backup and take off-site. Probably a bit of overkill, but that is my scheme that I have in place. at this time.
0
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 12309677
Nightly fulls strike me as overkill, yes.  I'd recommend weekend fulls, and a differential every night.  Use 1-2 tapes for the full (as needed) and the differentials will probably fit on 1 tape for the week.  Save you a lot of tapes doing it that way and you are pretty much as secure as if you were doing nightly fulls.  Restores just take a little longer if the whole system goes down.  Otherwise, they might be a little faster because you don't have to search through the entire tape for a file (if it's been changed).
0
 

Author Comment

by:stressbuny
ID: 12309736
I know it's a bit of overkill, but the company I am working for is not very "network" savvy, so I have to do restores of files rather often. I think I may see about switching to a 20/40 Tape, and seeing if the boss bites on that. When I started here, there was NO backup whatsoever; everyone was "responsible" for their own drives, though they had a file server.

Thanks for the help on this one, I have been pulling my hair out for weeks, thinking there was something wrong with the drive or the software. Swapped out the drive under warranty, upgraded software, reinstalled windows, etc. Compression ratios should be given a better description as to advertising.

I will look at DLT or SDLT later, once we exceed capacity. We have only added about 2 GB of data in 3 years.
0
 
LVL 96

Accepted Solution

by:
Lee W, MVP earned 20 total points
ID: 12309771
Another suggestion - consider getting a Windows 2003 server as their file server and using Volume Shadow Copy - I implemented that at my current position and it's helped quickly recover files on two occasions in the last month or so.
0
 

Author Comment

by:stressbuny
ID: 12309802
Yeah, company probably doesn't want to spend the cash. Had to pull tooth and nail to get SBS 2000 server; old server was a Win98 file server. Didn't even have DSL when I got here, was using a dial-up AOL account. Even though we are running SBS 2000 with Exchange now, it's on a PC, not a RAID machine. We only have 10 employees, so the system we have in place is 100 times better than when I started.

Thanks for all the help. I am trying to run my backup with Hardware only and Software only to see if one does better at compression than the other. If neither works, probably going to switch tape capacity till that is exceeded.
0
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 12310058
Could be wrong, but I think if the backup software detects hardware compression, it disables software compression.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
RAID 1 volatile subkey Windows 7 64 bit 14 81
Uniden UDW20055 3 118
is there a storage limitation on blogger.com? 4 96
EMC vplex question 1 64
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question