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

Backup to the Clode - No Excuses Expand / Collapse
Author
Message
Posted Saturday, August 8, 2009 1:00 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, January 10, 2014 7:20 AM
Points: 175, Visits: 723
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
Posted Sunday, August 9, 2009 4:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 2, 2013 6:56 AM
Points: 18, Visits: 120
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
Posted Sunday, August 9, 2009 5:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:01 AM
Points: 11,194, Visits: 11,165
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
Posted Sunday, August 9, 2009 7:55 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:20 AM
Points: 587, Visits: 2,527
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
Posted Sunday, August 9, 2009 12:44 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 42,962, Visits: 36,115
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
Posted Sunday, August 9, 2009 12:51 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 42,962, Visits: 36,115
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
Posted Sunday, August 9, 2009 5:21 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:01 AM
Points: 11,194, Visits: 11,165
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
Posted Sunday, August 9, 2009 11:12 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight 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
Posted Monday, August 10, 2009 2:23 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: 2 days ago @ 4:06 AM
Points: 988, Visits: 804
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
Posted Monday, August 10, 2009 6:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 7, 2014 5:53 AM
Points: 19, Visits: 139
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse