| Author |
Topic |
|
aikea
Starting Member
3 Posts |
 Posted - 2009-04-01 : 15:39:49
|
| Hard disk, tape or usb pen drive are all good backup devices, but I have never tried to use DVDRW disc. I always think DVDRW = data loss.But I have seen someone already use rewritable CD or DVD as primary backup device. I wonder what is your expirerence? How do you overcome the data loss issue? Consider that a slightly scratch on disk can ruin the whole thing. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-01 : 16:00:17
|
quote:
usb pen drive are all good backup devices
Ummmm, no, a USB key drive should never be used for backups. In fact no USB connected device should be used for this purpose, except maybe for dire emergencies when there is absolutely no other way to get a backup. |
 |
|
|
aikea
Starting Member
3 Posts |
Posted - 2009-04-01 : 16:12:07
|
quote:
Originally posted by robvolk
quote:
usb pen drive are all good backup devices
Ummmm, no, a USB key drive should never be used for backups. In fact no USB connected device should be used for this purpose, except maybe for dire emergencies when there is absolutely no other way to get a backup.
Well, I wonder what the disadvantage is?Usb pen drive or Solid state drive in general are pretty good medium in my opinion.The data in a solid state drive can last quite long, over 10 years I think. It has better resistance to shock and almost immune to mechanical failure.Or do you mean the "usb" interfaced deviced is not good backup device? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-01 : 16:36:43
|
| No, they're not good backup devices. The throughput is too low, and flash memory has a limited number of writes. A USB hard drive is likely to be less reliable than a server grade drive, and since it's portable it will experience more mechanical shock. And it's easy to drop a pen drive and step on it.The real point I'm trying to make is don't start using them now for small, unimportant databases thinking it will be OK as your databases grow and get more important. It's also a security issue to have corporate data on any portable device, especially a small one that can fit in a pocket or otherwise get lost. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
aikea
Starting Member
3 Posts |
Posted - 2009-04-01 : 19:20:39
|
quote:
Originally posted by robvolk
No, they're not good backup devices. The throughput is too low, and flash memory has a limited number of writes. A USB hard drive is likely to be less reliable than a server grade drive, and since it's portable it will experience more mechanical shock. And it's easy to drop a pen drive and step on it.The real point I'm trying to make is don't start using them now for small, unimportant databases thinking it will be OK as your databases grow and get more important. It's also a security issue to have corporate data on any portable device, especially a small one that can fit in a pocket or otherwise get lost.
Thanks for the information. I need to be carefull now.Most of my backup is made to the hard drive then copied to use pen drive, placed in a safe. May be I have to work out a new backup plan. |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-01-15 : 16:16:15
|
| I have use CD-R to backup mp3 files before and after the cd was stored for a year the layer on the cd started to peel off itself. What would have happened if I have used CD-R to backup a production database. It would have been really messed up. |
|
|
|
|
Is DVDRW a viable backup device?