Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup to the Clode - No Excuses


Backup to the Clode - No Excuses

Author
Message
GSquared
GSquared
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14385 Visits: 9729
File-size vs bandwidth prevents me from doing that currently. Tapes get made of the backups, nightly, and get shipped to a different state.

Means there's an overnight delay (at best) for getting them back, if needed, and even that has extra charges on it, but it's better than taking two days to upload a daily backup.

With smaller databases, I have backed up to a location in a different state. Same continent, different tectonic zone. Main concern with that data center was hurricanes (it was in Houston), so having the backups FTP to a backup data center a thousand miles from the coast was a good idea.

That wasn't bank data, or anything critical like that. It's loss would have shut down the company, but nothing much beyond that. But a separate, backup data center was cheap and easy enough that it made sense.

With more critical data, like Phil's or Gail's banks, a hardened data center is easy enough to build, if you can afford it. Bunker/vault technology is pretty good these days. Lots of studies on how to make those virtually indestructible was done in the 60s, 70s and 80s. Anything that has a reasonable chance of surviving a nuclear war between the US and USSR (that was the threat then), can certainly withstand a plane crashing into it.

- 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
jhanweck
jhanweck
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 4
Pros:
- Cloud is distributed; therefore, in theory, robust and redundant.
- Cloud can be inexpensive as archived storage.

Cons:
- Public clouds (e.g., Amazon) are not secure; few financial institutions (banks, brokers) allow their DBAs to place sensitive information on the cloud, even if encrypted.
- Public clouds can be expensive for archival storage, moreso than a redundant leased data center.
- Network bandwidth to public clouds is poor, whereas leased lines can be run to non-cloud datacenters with relative ease.
- In practice, for large storage, public clouds are often not distributed or redundant: the data resides on a particular set of disks, somewhere.

My personal preference for large backup is a redundant datacenter (or leased storage) at a reasonable distance from the primary data center. As a Wall Streeter on 9/11, I can assure you that 50 meters is not a reasonable distance, and that while one might be able to crash a plane atop a datacenter, the ensuing fire and water damage can make the structural issues moot.
dbaInTraining
dbaInTraining
Right there with Babe
Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)

Group: General Forum Members
Points: 769 Visits: 253
Just an observation, but it seems to me that I read a lot these days of security breaches due to lost, misplaced, and/or compromised backups. It seems to me the greater risk lies not it a major catastrophe, but in the very risks that entail using the cloud for backup storage. Unless, of course, you are encrypting the backups....
jay-h
jay-h
SSC Eights!
SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)

Group: General Forum Members
Points: 931 Visits: 2222
Paul White (8/9/2009)
If a 747 were to crash into our data centre, I wonder how high up the list of concerns wondering if we had backups in the cloud would be...Laugh


Actually it's often not so dramatic. A crashed airliner is a rare risk. Flood, blizzard, hurricane are cases where a region might be affected, either directly or through power/communication failures (ice storms have a history of bringing down large areas).

...

-- FORTRAN manual for Xerox Computers --
Robert.Smith-1001156
Robert.Smith-1001156
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 122
The Cloud is a lovely analogy, but that's all it is - an analogy. You're still forced to deal with realities like 'What are the privacy laws in the country where my data is physically stored?' and 'Can I even tell which country my data is stored in and how will I know if the location changes?'.

The US Patriot Act, for example, left those of us outside the US scrambling to ensure that no private or confidential data was being stored on servers in the US where it could be subject to arbitrary search and seizure. I'm not interested in going through that again.

I'll stick to offsite storage in a reassuringly physical vault a few miles away, thanks anyway.

Robb
Michael Valentine Jones
Michael Valentine Jones
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3264 Visits: 11771
It seems like a lot to send over the network for a large datacenter; we have enough issues just getting them from disk to tape every day.

I took a quick look and we have about 8 TB daily of compressed SQL Server backups for just one site.
Michael Valentine Jones
Michael Valentine Jones
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3264 Visits: 11771
Robert.Smith (8/10/2009)

...The US Patriot Act, for example, left those of us outside the US scrambling to ensure that no private or confidential data was being stored on servers in the US where it could be subject to arbitrary search and seizure. I'm not interested in going through that again...

Guess that works, as long as you're sure that your own government won't give up the info on request from the US. Or your ISP, or tape storage center, etc.

US network providers have been very compliant (cowardly) about giving up info to Chinese authorities seeking to suppress dissent without even requiring warrants from US courts.
starunit
starunit
SSC Veteran
SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)

Group: General Forum Members
Points: 258 Visits: 2566
We've been backing up to the 'cloud' for a few years now, but the size of our databases are not so large as to cause a problem, I guess.
Or, since the backup company we've subscribed to uses the VSS shadow writer to capture disc-writes and sends those every 15 minutes.. maybe their's just not too much there to cause a bottleneck... I really have no idea exactly how much it sends through the pipe, but it's not noticable. And the test-restores work just fine.
Of course, we also back up db's nightly, and tranaction logs hourly (to a separate sever), and back up those backups to tape nightly, too.
I don't bother taking the local, physical backups off-site anymore since we have the copy 'out there'.. they're for my own comfort and convenience.
Cheers,
Mark

Mark
Just a cog in the wheel.
GSquared
GSquared
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14385 Visits: 9729
Brad: I have to ask, is there a way for you to fix the title of this thread? The article title is correct, the thread title references backing up to "the Clode". Doesn't actually matter, but I'm enough of a compulsive proofreader that my attention just keeps sticking on that point.

- 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
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
SSC Veteran
SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)

Group: General Forum Members
Points: 216 Visits: 730
Brad: I have to ask, is there a way for you to fix the title of this thread? The article title is correct, the thread title references backing up to "the Clode". Doesn't actually matter, but I'm enough of a compulsive proofreader that my attention just keeps sticking on that point.


I have asked for the typo to be fixed, as I don't have permission to do this myself, and I am still waiting for it to be fixed. I hand off the content to others, and they enter it into the system to be published.

Brad M. McGehee
DBA
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search