THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

High-Availability White Papers and Resources for SQL Server

In foreground, attendee makes dreaded "shoot myself" hand sign to the speaker.

I was just telling the good people of Charlotte about how they (and how YOU) need to read all things by Paul Randal (blog | twitter), except for all of his cheesy romance novels like Caress and Conquer written under the nom de plum of Connie Mason.

There's lots more good stuff from Paul, just not romantic.

This is a 'so-last-version' whitepaper describing  five common high-availability and disaster-recovery architectures deployed by customers, along with a case study of each. Although the white paper is specific to SQL Server 2008 R2 and isn't updated for AlwaysOn features, it's still really, really good.  It covers:

  • Failover Clustering for High Availability with Database Mirroring for Disaster Recovery
  • Database Mirroring for High Availability and Disaster Recovery
  • Geo-Clustering for High Availability and Disaster Recovery
  • Failover Clustering for High Availability Combined with SAN-Based Replication for Disaster Recovery
  • Peer-to-Peer Replication for High Availability and Disaster Recovery

You can get it from this link.  Not everything is transferable to new AlwaysOn technologies, but then again AlwaysOn is an Enterprise Edition feature.  So the database mirroring recommendation can be upsized, in many if not all cases, to SQL Server 2012, while the SAN and peer-to-peer recommendations continue to hold fast.

In addition, I encourage you to get up to speed on AlwaysOn.  There are two great AlwaysOn FAQs that I recommend.  The first is Microsoft’s official AlwaysOn FAQ at http://msdn.microsoft.com/en-us/sqlserver/gg508768.aspx.  The second comes from my buddy and high-availability expert Allan Hirt (blog | twitter) at http://www.sqlha.com/2012/04/13/allans-alwayson-availability-groups-faq/.

To get started with AlwaysOn, check out http://msdn.microsoft.com/en-us/library/cc645581.aspx.

Enjoy,

-Kev

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Gene said:

No pic

July 26, 2012 2:04 PM
 

Neil Hambly said:

Thanks will be reading that this week

July 29, 2012 2:55 PM
 

Chuck said:

In the whitepaper: I particularly liked this, on the obviously-MS-provided copyright page:

Microsoft, <plus, in alphabetical order, all Microsoft trademarks used in your white paper> are trademarks of the Microsoft group of companies.

August 5, 2012 8:13 AM
 

Disaster recovery SQL server said:

Very useful post. Thanks for providing complete information on <a href="https://www.cloudendure.com/disaster-recovery/">disaster recovery SQL server</a>.

November 27, 2017 8:51 AM
 

obat batuk kronis said:

https://goo.gl/KTrjVR Obat herbal kolesterol terbaik

https://goo.gl/9qCgf9 Obat Batuk Kronis Alami Terbaik

https://goo.gl/HQh67p Masker wajah alami untuk menghilangkan jerawat

https://goo.gl/4UJxUL Obat liver alami aman dan terbaik

https://goo.gl/j3PFHJ Obat herbal sinusitis kronis terbaik

https://goo.gl/W5W8F9 Obat bronkitis anak secara alami

https://goo.gl/2AsGLu Obat Kanker Payudara terbaru 2018

https://goo.gl/ssFQGs Cara meningkatkan nafsu makan secara alami

https://goo.gl/KSnnFb Obat herbal diabetes menurunkan gula darah

https://goo.gl/ngiymL Obat herbal kusta terbaik

https://goo.gl/ZsjaLf Obat benjolan di leher tanpa operasi

https://goo.gl/arrkfe Obat Herbal Kanker Otak tuntas hingga akar

https://goo.gl/VBFyi2 Obat TBC alami aman tanpa efek samping

https://goo.gl/ooXyhS Obat radang amandel sembuh tanpa operasi

https://goo.gl/94gZFX Obat asam urat alami tanpa efek sampinfg

https://goo.gl/Ld4VKF Obat tetes Sariawan secara alami

https://goo.gl/8v2oKL Cara mengobati mata bengkak dengan cepat

https://goo.gl/pnP3nA Obat tradisional kanker lambung terbaik

https://goo.gl/96UaW3 Obat kanker paru paru

https://goo.gl/bjzQzS Obat usus buntu alami tanpa operasi

https://goo.gl/PUDELN Obat asam lambung naik cara alami

August 27, 2018 8:29 PM

Leave a Comment

(required) 
(required) 
Submit

About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.

This Blog

Syndication

Archives

Privacy Statement