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
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

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

Brad M. McGehee
DBA
PrimeSyntax
PrimeSyntax
SSC-Enthusiastic
SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)

Group: General Forum Members
Points: 182 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
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: General Forum Members
Points: 36848 Visits: 11361
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
SSCarpal Tunnel
SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)

Group: General Forum Members
Points: 4966 Visits: 3031
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 (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)

Group: General Forum Members
Points: 234039 Visits: 46366
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 (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)SSC Guru (234K reputation)

Group: General Forum Members
Points: 234039 Visits: 46366
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
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: General Forum Members
Points: 36848 Visits: 11361
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 (745 reputation)Right there with Babe (745 reputation)Right there with Babe (745 reputation)Right there with Babe (745 reputation)Right there with Babe (745 reputation)Right there with Babe (745 reputation)Right there with Babe (745 reputation)Right there with Babe (745 reputation)

Group: General Forum Members
Points: 745 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
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1708 Visits: 991
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-Enthusiastic
SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)

Group: General Forum Members
Points: 133 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