SQL Clone
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
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
SSChasing Mays
SSChasing Mays (620 reputation)SSChasing Mays (620 reputation)SSChasing Mays (620 reputation)SSChasing Mays (620 reputation)SSChasing Mays (620 reputation)SSChasing Mays (620 reputation)SSChasing Mays (620 reputation)SSChasing Mays (620 reputation)

Group: General Forum Members
Points: 620 Visits: 730
Comments posted to this topic are about the item Backup to the Cloud - No Excuses

Brad M. McGehee
DBA
PrimeSyntax
PrimeSyntax
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 133
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.
Paul White
Paul White
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15636 Visits: 11355
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



Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Phil Factor
Phil Factor
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2002 Visits: 2971
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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86989 Visits: 45267
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, MVP, M.Sc (Comp Sci)
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


GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86989 Visits: 45267
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, MVP, M.Sc (Comp Sci)
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


Paul White
Paul White
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15636 Visits: 11355
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
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
WHITE_DRAGON999
WHITE_DRAGON999
Right there with Babe
Right there with Babe (731 reputation)Right there with Babe (731 reputation)Right there with Babe (731 reputation)Right there with Babe (731 reputation)Right there with Babe (731 reputation)Right there with Babe (731 reputation)Right there with Babe (731 reputation)Right there with Babe (731 reputation)

Group: General Forum Members
Points: 731 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. Smile
david.wright-948385
david.wright-948385
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1238 Visits: 979
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.
karmour
karmour
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 176
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.



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