<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
»
Backup to the Clode - No Excuses
28 posts, Page 1 of 3
1
2
3
»
»»
Backup to the Clode - No Excuses
Rate Topic
Display Mode
Topic Options
Author
Message
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
Posted Saturday, August 08, 2009 1:00 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175,
Visits: 719
Comments posted to this topic are about the item
Backup to the Cloud - No Excuses
Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #767431
PrimeSyntax
PrimeSyntax
Posted Sunday, August 09, 2009 4:53 AM
Grasshopper
Group: General Forum Members
Last Login: Yesterday @ 1:34 AM
Points: 18,
Visits: 115
We are looking into using the cloud as an extension of our datacenter, where backup fit in naturally. The challenge is to find the tools to do and manage it and preferably more than one that supports more than one cloud vendor. Access control is a major concern, encryption solves some of the problems. We haven't had time to any research into the tools area yet.
Post #767484
Paul White
Paul White
Posted Sunday, August 09, 2009 5:03 AM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 10:48 AM
Points: 10,990,
Visits: 10,578
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...
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #767485
Phil Factor
Phil Factor
Posted Sunday, August 09, 2009 7:55 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:10 AM
Points: 535,
Visits: 2,295
When I was working for a national UK bank, a while back, a passenger jet crashed within half a mile of our secure data center (placed outside the metropolis, in open country). It caused a major exercise in working out what would have been the effect on our operations if the plane had crashed a few yards closer. The answer, they concluded, would probably have been the disappearance of the bank. They'd never have recovered from the mess, and what is worse, countless thousands of depositors would have been unable to get their money out due to the disappearance of the necessary records of their account. This, in turn, could have caused widespread economic chaos. The bank therefore worked out a new system to enable it to survive such a catastrophe. This was passed on to other financial institutions and has since served well in subsequent natural disasters accidents, and terrorist organizations.
Best wishes,
Phil Factor
Simple Talk
Post #767497
GilaMonster
GilaMonster
Posted Sunday, August 09, 2009 12:44 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:13 AM
Points: 38,105,
Visits: 30,396
Depends where you are sitting in the world. Where I am, backing up into the cloud is just not an option, it's not security or risk, it's simple time, bandwidth and cost.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #767536
GilaMonster
GilaMonster
Posted Sunday, August 09, 2009 12:51 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:13 AM
Points: 38,105,
Visits: 30,396
Phil Factor (8/9/2009)
When I was working for a national UK bank, a while back, a passenger jet crashed within half a mile of our secure data center (placed outside the metropolis, in open country). It caused a major exercise in working out what would have been the effect on our operations if the plane had crashed a few yards closer. The answer, they concluded, would probably have been the disappearance of the bank.
Bank I used to work for had 2 data centres, 15 km apart, both (mostly) capable of running all the bank's systems. Allegedly the primary data centre was so strong that you could crash a plane on top of it and still carry on processing from there. Fortunately they've never had to test that.
Edit: Missing letters...
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #767539
Paul White
Paul White
Posted Sunday, August 09, 2009 5:21 PM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 10:48 AM
Points: 10,990,
Visits: 10,578
Fair point.
Leaving aside the impact on the economy of a failed bank (though that has been demonstrated to be manageable in recent times
) having a plane land on your data centre or head office (or both for many companies) would be the end of the company regardless of backups. Data is not an organization's main asset - people are.
Paul
@Gail: It must have been a very complex query to generate a 'plan' heavy enough to trouble a steel-and-concrete building "laugh:
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #767576
WHITE_DRAGON999
WHITE_DRAGON999
Posted Sunday, August 09, 2009 11:12 PM
Right there with Babe
Group: General Forum Members
Last Login: Monday, October 29, 2012 5:02 PM
Points: 723,
Visits: 53
How far should the offsite storage location be? A disaster that would strike and cripple the whole city, then no place is secure within that city.
Perhaps organisations need to look to storing data half way across the world. Or at least, have a copy of their databases sent across to atleast 3 continents. (organsations in US, could have their data sent to a city in Asia, Europe and Australia) - This is a surefire guarantee atleast. :)
Post #767633
david.wright-948385
david.wright-948385
Posted Monday, August 10, 2009 2:23 AM
SSC Eights!
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:41 AM
Points: 909,
Visits: 596
I'd warn against routing backups to a central location and from there to other locations. The source of the data (the database server) is a bottleneck you can't avoid. The sooner you diverge routes to avoid subsequent bottlenecks, the better. If your central location fails (especially through connectivity) then you've lost two backups not just one, so it only takes the source server to fail and you're stuffed.
Post #767673
karmour
karmour
Posted Monday, August 10, 2009 6:43 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, June 07, 2013 10:36 AM
Points: 19,
Visits: 133
If you have 100gigs of backup files what is the realistic bandwidth needs to move these to the cloud? Seems that by the time I get the files into the cloud I would be moving the next days files. Same with using them to restore.
Post #767805
« Prev Topic
|
Next Topic »
28 posts, Page 1 of 3
1
2
3
»
»»
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.
