<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
The Institute for Backup Trauma
12 posts, Page 1 of 2
1
2
»»
The Institute for Backup Trauma
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Saturday, December 18, 2010 11:36 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 9:03 PM
Points: 31,406,
Visits: 13,723
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
OCTom
OCTom
Posted Monday, December 20, 2010 6:59 AM
SSCrazy
Group: General Forum Members
Last Login: Friday, May 17, 2013 1:42 PM
Points: 2,012,
Visits: 2,839
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
Nakul Vachhrajani
Nakul Vachhrajani
Posted Monday, December 20, 2010 7:17 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:52 AM
Points: 1,277,
Visits: 1,608
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:
@nakulv_sql
Google Plus:
+Nakul
Post #1037178
Ron Porter
Ron Porter
Posted Monday, December 20, 2010 7:27 AM
Valued 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
Dave Schutz
Dave Schutz
Posted Monday, December 20, 2010 9:32 AM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 12:02 PM
Points: 1,630,
Visits: 566
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
Elliott Whitlow
Elliott Whitlow
Posted Monday, December 20, 2010 10:01 AM
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854,
Visits: 4,873
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
SQLRNNR
SQLRNNR
Posted Monday, December 20, 2010 10:16 AM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 6:30 PM
Points: 18,733,
Visits: 12,330
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 2008
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
Ron Porter
Ron Porter
Posted Monday, December 20, 2010 10:18 AM
Valued 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
jessicadisney
jessicadisney
Posted Monday, December 20, 2010 10:46 AM
Grasshopper
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
Elliott Whitlow
Elliott Whitlow
Posted Monday, December 20, 2010 11:54 AM
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854,
Visits: 4,873
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 »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
