Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

The Need for Tape Expand / Collapse
Author
Message
Posted Thursday, March 26, 2009 9:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 8:59 AM
Points: 23, Visits: 106
My boss once asked me how we can stop hackers from attempting to hack our Web site. We get the most hack attempts during the night when the other side of the world is awake and we are sleeping.

My response to him "Either get all of these losers gainfully employed or at least help them 'get a life'."
Post #684238
Posted Thursday, March 26, 2009 9:24 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:11 PM
Points: 31,368, Visits: 15,837
blandry (3/26/2009)

What we need are much more stringent legal avenues to meet this problem. This is just the sad reality of it.


Here, here. Let some of these kids dig ditches or pound nails as a punishment for a year.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #684263
Posted Thursday, March 26, 2009 9:32 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:11 PM
Points: 31,368, Visits: 15,837
Tape allows for a disconnected medium that isn't active. Moving to disk, often means that you have a process there. you could make this offsite, and offline, but then you are connecting some of the time, which is when a hacker (or more likely, insider) can attack.

If you move to tape, and physically remove tapes from machines, you have a layer of protection in the physical act.

this is less a hacker concern, and more a disgruntled employee concern. A good reason to have someone else other than the admin handle tapes. Even at a small company, I used to do the backups, but we had a secretary handle the tapes. Granted, I could have stopped backups, but we did perform a restore from tape periodically and the secretary got the tape from the offsite company, so I would have a limited window to do damage.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #684271
Posted Thursday, March 26, 2009 9:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 7,179, Visits: 15,776
Steve Jones - Editor (3/26/2009)
blandry (3/26/2009)

What we need are much more stringent legal avenues to meet this problem. This is just the sad reality of it.


Here, here. Let some of these kids dig ditches or pound nails as a punishment for a year.


That's all fine an dandy in the case of the disaffected youth concept. The reality however seems to be very different, since there is an increasing amount of such incidents which are government-sponsored (from certain countries in Asia and the Middle East in particular) or, tolerated by said government swhen used to neutralize threats to the local economy, or - just not prosecutable in said coutries. Just look at the published events during the US presidential elections (From China, Niger, North Korea just to cite a few), and it becomes fairly clear that you can't expect that legal channels will tackle this beast.

Once again - our dogged attachment to open networks/open lines of communication leaves us with no other option than making sure that a. we are protected as best we can in our online systems and b. that we maintain a certain set of offline systems or backups to account for those incidents where a breach occurs.


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #684298
Posted Thursday, March 26, 2009 10:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 10, 2012 6:08 PM
Points: 1,156, Visits: 801
Steve Jones - Editor (3/26/2009)[hrTape allows for a disconnected medium that isn't active. Moving to disk, often means that you have a process there. you could make this offsite, and offline, but then you are connecting some of the time, which is when a hacker (or more likely, insider) can attack.

If you move to tape, and physically remove tapes from machines, you have a layer of protection in the physical act.

this is less a hacker concern, and more a disgruntled employee concern. A good reason to have someone else other than the admin handle tapes. Even at a small company, I used to do the backups, but we had a secretary handle the tapes. Granted, I could have stopped backups, but we did perform a restore from tape periodically and the secretary got the tape from the offsite company, so I would have a limited window to do damage.


With relation to backups, there is no difference between disk and tape, only that disk is far faster. This equates to less connected time.

I'd never go back to tape if I have a choice about it. Hot swap SCSI was difficult, but USB has turned the issue around. I've been backing up to removeable HD's for 5+ years now, and no regrets.
Post #684306
Posted Thursday, March 26, 2009 10:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 11, 2014 3:10 AM
Points: 1,274, Visits: 1,987
Tapes are simple and compact. I haven't looked recently, but 40Gb tapes were available 5 years ago.

DVDs can't match the storage (haven't checked Blu-Ray, but the technologies a bit new for general use).

Removable hard disks can match or execeed the storage but come with a mass of sensitive electronics built into the media which could fail.

Hence tape is still the backup medium of choice in most situations.


Derek
Post #684317
Posted Thursday, March 26, 2009 10:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 10, 2012 6:08 PM
Points: 1,156, Visits: 801
Derek Dongray (3/26/2009)
Tapes are simple and compact. I haven't looked recently, but 40Gb tapes were available 5 years ago.

DVDs can't match the storage (haven't checked Blu-Ray, but the technologies a bit new for general use).

Removable hard disks can match or execeed the storage but come with a mass of sensitive electronics built into the media which could fail.

Hence tape is still the backup medium of choice in most situations.


300 GB HD were available 5 years ago (and bigger). Tape not sensitive?! Very funny. And do you enjoy the time spent backing up to or restoring from tape?

The speed and capacity of hard disk far outweighs any argument tape can propose. Lets see someone pull off a backup to a mirrored set of tapes... yes, it can be done, but whoa... Electromagnetic interferrence will smoke a tape much easier than a disk.

Championing tape in this day is like saying we should go back to 486 DX4 100MHZ PCs.
Post #684354
Posted Thursday, March 26, 2009 11:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 8:17 AM
Points: 297, Visits: 335
After a read, a re-read, and digesting the posts before mine, I've come to the conclusion that the best concept in the discussion is using a pull based method to get the backups from the main server(s) to the backup servers. (Whether the backups are stored on tape or disk). It means the server being backed up doesn't even have a clue (much less any access rights) to where it's backups might be being copied.

I am one who has abandoned tape a long time ago. But we've been pushing backups to another server, I'm going to reverse that.

Thanks for the article, and for provoking some thought!



Student of SQL and Golf, Master of Neither
Post #684392
Posted Thursday, March 26, 2009 11:35 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, December 19, 2014 11:42 AM
Points: 821, Visits: 2,028
I knew a DBA who:
(1) Backed up using a script
(2) zipped up the backup via command line
(3) Used a QIC 40 tape to backup the zip.


ATB

Charles Kincaid

Post #684417
Posted Thursday, March 26, 2009 11:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:58 AM
Points: 13,872, Visits: 9,600
Backup to USB HDDs is pretty good physical alternative to tape. They do take up a bit more shelf space, and cost more.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #684421
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse