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 12»»

The Institute for Backup Trauma Expand / Collapse
Author
Message
Posted Saturday, December 18, 2010 11:36 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 4:10 PM
Points: 33,095, Visits: 15,202
Comments posted to this topic are about the item The Institute for Backup Trauma






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1036900
Posted Monday, December 20, 2010 6:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:57 AM
Points: 2,518, Visits: 3,718
Since this editorial is 5 years old, I wonder how many are now using disk instead of tape. We still use tape but have discussed disk backup?

And, is a cloud service better than in-house to disk backups?
Post #1037163
Posted Monday, December 20, 2010 7:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:52 AM
Points: 1,403, Visits: 1,814
I would still prefer a tape for shipment offsite. The reason? No impact of mechanical forces!
Secondly, tapes have stood the test of time. Optical disks are a good alternate, but I am not sure if anyone has ever tried to recover 10 year old business critical backup from an optical disk.

My home backup strategy is to have two external drives for regular monthly backups. The laptop's data goes into the desktop every week, and then every month, that is flushed on to the external drives. Every year, I copy it over to optical disks. Heavy-weights (videos/music/pictures) which are also available on the desktop are removed from the external drives and only the essential work/study data remains ready for a new year.


Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1037178
Posted Monday, December 20, 2010 7:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 28, 2011 8:03 AM
Points: 70, Visits: 316
We backup exclusively to disk and have never been happier. We've always hated tape with a passion, mostly because they've been so unreliable (tape-eating drives and media not readable on identical replacement hardware because of imperfect head alignment). We've experimented with a number of disk-based systems over the years and have now settled on two NAS devices, one on site and the other off site. (We have our own fiber between two buildings separated by about a block, so off site doesn't mean off network.)
Post #1037185
Posted Monday, December 20, 2010 9:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:15 PM
Points: 1,791, Visits: 594
We run all our backups daily to tape and keep some tapes offsite. Would love to have disk storage but not in the budget. I do keep 3 days of SQL backups on the network as a convenience, easier and quicker than tape.
Post #1037250
Posted Monday, December 20, 2010 10:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
All the environments I've been in typically use a two hop approach, backups are written to disk and the backups are then swept to tape which are taken offsite. If you have a LOT of servers this can be problematic as the network becomes a bottleneck.

And as always you have to periodically TEST that the tapes are readable, at a former employer we had to spend like $15K to send a couple tapes out for recovery when there was a disaster and a server died. They hadn't been testing and just assumed that if it was on tape it was OK. Altogether I think for the better. But 3 days of downtime, a bunch of idle people, and $15K for recovery, I would guess the costs were over $100K..

This was a HARD lesson and there was real change after to make sure the backups were good.

CEWII
Post #1037268
Posted Monday, December 20, 2010 10:16 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:30 PM
Points: 21,290, Visits: 14,982
We use a two-op approach but don't use tape backup anymore. We backup to disk and then those backups are retrieved into an appliance that is disk based. The backups once there are mirrored between sites for DR.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1037279
Posted Monday, December 20, 2010 10:18 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 28, 2011 8:03 AM
Points: 70, Visits: 316
Elliott Whitlow (12/20/2010)
All the environments I've been in typically use a two hop approach, backups are written to disk and the backups are then swept to tape which are taken offsite. If you have a LOT of servers this can be problematic as the network becomes a bottleneck.

And as always you have to periodically TEST that the tapes are readable, at a former employer we had to spend like $15K to send a couple tapes out for recovery when there was a disaster and a server died. They hadn't been testing and just assumed that if it was on tape it was OK. Altogether I think for the better. But 3 days of downtime, a bunch of idle people, and $15K for recovery, I would guess the costs were over $100K..

This was a HARD lesson and there was real change after to make sure the backups were good.

CEWII


Even with testing, we've had to send tapes out for recovery. One tape drive died and the new one wouldn't read the tapes because the old drive apparently had head alignment problems. It wrote and read tapes just fine, but the tapes created were not readable even on supposedly identical hardware.
Post #1037281
Posted Monday, December 20, 2010 10:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 26, 2011 2:21 PM
Points: 14, Visits: 138
We do both as well. Grandfather system, full weekly, daily incremental, all written to the disk, then nightly to the tape for off site. Looked into the disk only options but no reliable network (fiber) that can handle the data transfer requirements in a timely manner. The tapes seem like they are better than they used to be. Direct SCSI from the backup server to the tape drive makes the backup window really reasonable.


Post #1037295
Posted Monday, December 20, 2010 11:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
CirquedeSQLeil (12/20/2010)
We use a two-op approach but don't use tape backup anymore. We backup to disk and then those backups are retrieved into an appliance that is disk based. The backups once there are mirrored between sites for DR.
I've seen that as well, as disk costs have come down this has become more practical. Just like I don't use DVD's for personal backup anymore, I keep several copies of data on external hard drives, so just in case one gets destroyed I am not screwed. Or I use an online service like Norton Online Backup (NOBU). For the stuff I simply CANNOT lose I back it up to DVD's but that is rare.

I categorically don't like losing data I want to keep and will go to lengths to make sure it doesn't happen.

CEWII
Post #1037322
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse