![Page 1: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/1.jpg)
Building a SQL 2012 HA Solution for SharePoint(In under an hour)
Troy LanphierSenior SharePoint Solutions Developer – GUIO, LLC
Zero to High Availability in 60 Minutes
![Page 2: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/2.jpg)
2 | SharePoint Saturday Austin 2013
• Please turn off all electronic devices or set them to vibrate• If you must take a phone call, please do so in the hall• Wi-Fi is available, you will need your Guest ID/password
(at registration desk)• Feel free to tweet and blog during sessions. Remember to follow
@SPSATX and tag #SPSATX in your tweets!
THANK YOU FOR BEING A PART OF SHAREPOINT SATURDAY AUSTIN!
SharePoint Saturday Austin is hosted bythe Austin SharePoint User Group
(@AustinSPUG)
![Page 3: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/3.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll start:
![Page 4: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/4.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll start:
• MARS – Domain Controller
![Page 5: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/5.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll start:
• MARS – Domain Controller
• ROMULUS – Win Server 2012 (SQL bits installed)
![Page 6: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/6.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll start:
• MARS – Domain Controller
• ROMULUS – Win Server 2012 (SQL bits installed)
• REMUS – Win Server 2012 (SQL bits installed)
![Page 7: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/7.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll start:
• MARS – Domain Controller
• ROMULUS – Win Server 2012 (SQL bits installed)
• REMUS – Win Server 2012 (SQL bits installed)
• RHEA – Win Server 2012 (SP 2013 bits installed)
![Page 8: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/8.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll end up:
![Page 9: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/9.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll end up:
• MARS – Domain Controller
![Page 10: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/10.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll end up:
• MARS – Domain Controller
• WS 2012 Failover Cluster (ROMULUS and REMUS)
![Page 11: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/11.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll end up:
• MARS – Domain Controller
• WS 2012 Failover Cluster (ROMULUS and REMUS)
• SQL Server 2012 AlwaysOn Availability Group
![Page 12: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/12.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll end up:
• MARS – Domain Controller
• WS 2012 Failover Cluster (ROMULUS and REMUS)
• SQL Server 2012 AlwaysOn Availability Group
• (ROMULUS and REMUS Independent SQL Nodes)
![Page 13: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/13.jpg)
Today’s Goal – AlwaysOn in 60 Minutes
Where we’ll end up:
• MARS – Domain Controller
• WS 2012 Failover Cluster (ROMULUS and REMUS)
• SQL Server 2012 AlwaysOn Availability Group
• (ROMULUS and REMUS Independent SQL Nodes)
• RHEA – Win Server 2012 (SharePoint Configured)
![Page 14: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/14.jpg)
SQL Server High Availability
![Page 15: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/15.jpg)
SQL Server High Availability (By Edition)
SQL Server Business Intelligence and Standard:
![Page 16: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/16.jpg)
SQL Server High Availability (By Edition)
SQL Server Business Intelligence and Standard:
• Database Mirroring (Safety Full Only)
![Page 17: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/17.jpg)
SQL Server High Availability (By Edition)
SQL Server Business Intelligence and Standard:
• Database Mirroring (Safety Full Only)
• DEPRECATED in 2012, possibly unavailable thereafter
![Page 18: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/18.jpg)
SQL Server High Availability (By Edition)
SQL Server Business Intelligence and Standard:
• Database Mirroring (Safety Full Only)
• DEPRECATED in 2012, possibly unavailable thereafter
• Failover Clustering (Two Nodes Only)
![Page 19: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/19.jpg)
SQL Server High Availability (By Edition)
SQL Server Enterprise (and Developer):
![Page 20: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/20.jpg)
SQL Server High Availability (By Edition)
SQL Server Enterprise (and Developer):
• Database Mirroring
![Page 21: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/21.jpg)
SQL Server High Availability (By Edition)
SQL Server Enterprise (and Developer):
• Database Mirroring
• Still DEPRECATED
![Page 22: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/22.jpg)
SQL Server High Availability (By Edition)
SQL Server Enterprise (and Developer):
• Database Mirroring
• Still DEPRECATED
• Failover Clustering (OS Maximum)
![Page 23: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/23.jpg)
SQL Server High Availability (By Edition)
SQL Server Enterprise (and Developer):
• Database Mirroring
• Still DEPRECATED
• Failover Clustering (OS Maximum)
• AlwaysOn Availability Groups
![Page 24: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/24.jpg)
The Setup
![Page 25: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/25.jpg)
The Setup
Quorum Drive pre-built (5GB) on MARS (DC)
![Page 26: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/26.jpg)
The Setup
Quorum Drive pre-built (5GB) on MARS (DC)
Networking pre-built:
![Page 27: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/27.jpg)
The Setup
Quorum Drive pre-built (5GB) on MARS (DC)
Networking pre-built:
• Heartbeat NIC – Non-routed
• Storage – iSCSI NIC
• Intrafarm – All Farm Communications
![Page 28: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/28.jpg)
The Setup
Quorum Drive pre-built (5GB) on MARS (DC)
Networking pre-built:
• Heartbeat NIC – Non-routed
• Storage – iSCSI NIC
• Intrafarm – All Farm Communications
Firewalls Disabled
![Page 29: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/29.jpg)
Step 1Setting Up iSCSI Storage
![Page 30: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/30.jpg)
Setting Up iSCSI Storage
Ensure that Windows Firewall is Off, or configure TCP Ports
![Page 31: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/31.jpg)
Setting Up iSCSI Storage
Ensure that Windows Firewall is Off, or configure TCP Ports
Setup iSCSI Initiator on SQL Servers
![Page 32: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/32.jpg)
Setting Up iSCSI Storage
Ensure that Windows Firewall is Off, or configure TCP Ports
Setup iSCSI Initiator on SQL Servers
Setup iSCSI Target on DC
![Page 33: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/33.jpg)
Setting Up iSCSI Storage
Ensure that Windows Firewall is Off, or configure TCP Ports
Setup iSCSI Initiator on SQL Servers
Setup iSCSI Target on DC
Connect Storage in iSCSI Initiator
![Page 34: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/34.jpg)
Step 2Configure DNS and Install Failover Clustering
![Page 35: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/35.jpg)
Configure DNS and Failover Clustering
Initial DNS Entries
![Page 36: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/36.jpg)
Configure DNS and Failover Clustering
Initial DNS Entries
Cluster Installation
![Page 37: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/37.jpg)
Configure DNS and Failover Clustering
Initial DNS Entries
Cluster Installation
Assign Permissions in DNS to the A Record
![Page 38: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/38.jpg)
Configure DNS and Failover Clustering
Initial DNS Entries
Cluster Installation
Assign Permissions in DNS to the A Record
Quorum Drive Addition
![Page 39: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/39.jpg)
Step 3Configure Availability Groups
![Page 40: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/40.jpg)
Configure Availability Groups
Enable AlwaysOn Availability Groups
![Page 41: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/41.jpg)
Configure Availability Groups
Enable AlwaysOn Availability Groups
SQL Configuration
![Page 42: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/42.jpg)
Configure Availability Groups
Enable AlwaysOn Availability Groups
SQL Configuration
• Create Seed Database and Backup
![Page 43: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/43.jpg)
Configure Availability Groups
Enable AlwaysOn Availability Groups
SQL Configuration
• Create Seed Database and Backup
• Create Availability Group
• Create Availability Listener
![Page 44: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/44.jpg)
Configure Availability Groups
Enable AlwaysOn Availability Groups
SQL Configurations
• Create Seed Database and Backup
• Create Availability Group
• Create Availability Listener
• Build Backup Share
![Page 45: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/45.jpg)
Step 4Configure SharePoint 2013
![Page 46: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/46.jpg)
Step 5Adding SharePoint 2013 Content Databases to Availability Groups
![Page 47: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/47.jpg)
47 | SharePoint Saturday Austin 2013
• SQL Server 2012 AlwaysOn - http://technet.microsoft.com/en-us/sqlserver/gg490638.aspx• Features Supported by the Editions of SQL Server 2012 - http://
msdn.microsoft.com/en-us/library/cc645993.aspx
REFERENCES
![Page 48: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/48.jpg)
PLEASE FILL OUT SESSION EVALUATIONS AND
THANK YOU FOR ATTENDING!
![Page 49: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/49.jpg)
49 | SharePoint Saturday Austin 2013
THANKS TO OUR SPONSORS!
![Page 50: Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer – GUIO, LLC Zero to High Availability](https://reader035.vdocuments.us/reader035/viewer/2022062511/551b5d83550346dd1a8b657f/html5/thumbnails/50.jpg)
CONTACT INFORMATION:TROY LANPHIER
EMAIL: [email protected]:
HTTP://WWW.GUIO.COM/TROYTWITTER: @TROYLANPHIER