Search results matching tags 'SQL Server 2012', 'Database Mirroring', and 'Troubleshooting'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=SQL+Server+2012,Database+Mirroring,Troubleshooting&orTags=0Search results matching tags 'SQL Server 2012', 'Database Mirroring', and 'Troubleshooting'en-USCommunityServer 2.1 SP2 (Build: 61129.1)High-Availability White Papers and Resources for SQL Serverhttp://sqlblog.com/blogs/kevin_kline/archive/2012/07/26/high-availability-white-papers-and-resources-for-sql-server.aspxThu, 26 Jul 2012 15:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:44457KKline<div class="mceTemp" style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><div class="mceTemp"><a rel="attachment wp-att-2011" href="http://kevinekline.com/2012/07/26/high-availability-white-papers-and-resources-for-sql-server/charlotte-sql-ug/"><img class="size-medium wp-image-2011" title="Charlotte SQL UG" alt="" width="300" height="168" style="border:0px none;cursor:default;margin:0px;padding:0px;-webkit-user-drag:none;" src="http://kevinekline.com/wp-content/uploads/2012/07/Charlotte-SQL-UG-300x168.jpg"></a>In foreground, attendee makes dreaded "shoot myself" hand sign to the speaker.</div><p>I was just telling the good people of Charlotte about how they (and how YOU) need to read all things by Paul Randal (<a title="Paul Randal's Blog" href="http://www.sqlskills.com/BLOGS/paul/">blog</a>&nbsp;|&nbsp;<a title="Paul Randal's Twitter Feed" href="http://twitter.com/paulrandal">twitter</a>), except for all of his&nbsp;<a title="Maybe He Did Write a Romance Novel, Maybe He Didn't" href="http://www.amazon.com/forum/romance?cdForum=FxM42D5QN2YZ1D&amp;cdThread=Tx2769ZA6OCU1BD">cheesy romance novels</a>&nbsp;like&nbsp;<a title="Quite Possibly The Worst Romance Novel EVER" href="http://www.amazon.com/Caress-and-Conquer-ebook/dp/B006IUV50A/ref=sr_1_2?ie=UTF8&amp;qid=1343317555&amp;sr=8-2&amp;keywords=Caress+and+Conquer+by+Connie+Mason"><em>Caress and Conquer</em></a>&nbsp;written under the nom de plum of Connie Mason.</p><p>There's lots more good stuff from Paul, just not romantic.</p><p>This is a 'so-last-version' whitepaper describing &nbsp;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. &nbsp;It covers:</p><ul><li>Failover Clustering for High Availability with Database Mirroring for Disaster Recovery</li><li>Database Mirroring for High Availability and Disaster Recovery</li><li>Geo-Clustering for High Availability and Disaster Recovery</li><li>Failover Clustering for High Availability Combined with SAN-Based Replication for Disaster Recovery</li><li>Peer-to-Peer Replication for High Availability and Disaster Recovery</li></ul><p>You can get it from&nbsp;<a href="http://download.microsoft.com/download/5/B/D/5BD13FFA-5E34-4AE1-9AA0-C6E6951B8FC8/SQL%20Server%202008%20R2%20High%20Availability%20Architecture%20White%20Paper.docx">this link</a>. &nbsp;Not everything is transferable to new AlwaysOn technologies, but then again AlwaysOn is an Enterprise Edition feature. &nbsp;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.</p><p>In addition, I encourage you to get up to speed on AlwaysOn. &nbsp;There are two great AlwaysOn FAQs that I recommend.&nbsp; The first is Microsoft’s official AlwaysOn FAQ at&nbsp;<a href="http://msdn.microsoft.com/en-us/sqlserver/gg508768.aspx">http://msdn.microsoft.com/en-us/sqlserver/gg508768.aspx</a>.&nbsp; The second comes from my buddy and high-availability expert Allan Hirt (<a title="Allan Hirt, Mr. SQLHA" href="http://www.sqlha.com/">blog</a>&nbsp;|&nbsp;<a title="Allan Hirt's Twitter Feed" href="http://twitter.com/sqlha">twitter</a>) at&nbsp;<a href="http://www.sqlha.com/2012/04/13/allans-alwayson-availability-groups-faq/">http://www.sqlha.com/2012/04/13/allans-alwayson-availability-groups-faq/</a>.</p><p>To get started with AlwaysOn, check out&nbsp;<a href="http://msdn.microsoft.com/en-us/library/cc645581.aspx">http://msdn.microsoft.com/en-us/library/cc645581.aspx</a>.</p><p>Enjoy,</p><p>-Kev</p></div>