1 / 0

Quick Guide to Implementing SQL 2012 HA for SharePoint

Join Troy Lanphier in this informative session and learn how to build a high availability solution for SharePoint using SQL 2012 in just under an hour. Perfect for SharePoint administrators looking to enhance data reliability and accessibility.

drago
Télécharger la présentation

Quick Guide to Implementing SQL 2012 HA for SharePoint

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Zero to High Availability in 60 Minutes

    Building a SQL 2012 HA Solution for SharePoint (In under an hour) Troy Lanphier Senior SharePoint Solutions Developer– GUIO, LLC
  2. Thank You for being a part of SharePoint Saturday Austin! 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! SharePoint Saturday Austin is hosted bythe Austin SharePoint User Group (@AustinSPUG)

  3. Today’s Goal – AlwaysOn in 60 Minutes

    Where we’ll start:

  4. Today’s Goal – AlwaysOn in 60 Minutes

    Where we’ll start: MARS – Domain Controller

  5. Today’s Goal – AlwaysOn in 60 Minutes

    Where we’ll start: MARS – Domain Controller ROMULUS – Win Server 2012 (SQL bits installed)

  6. 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)

  7. 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)

  8. Today’s Goal – AlwaysOn in 60 Minutes

    Where we’ll end up:

  9. Today’s Goal – AlwaysOn in 60 Minutes

    Where we’ll end up: MARS – Domain Controller

  10. Today’s Goal – AlwaysOn in 60 Minutes

    Where we’ll end up: MARS – Domain Controller WS 2012 Failover Cluster (ROMULUS and REMUS)

  11. 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

  12. 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)

  13. 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)
  14. SQL Server High Availability

  15. SQL Server High Availability (By Edition)

    SQL Server Business Intelligence and Standard:

  16. SQL Server High Availability (By Edition)

    SQL Server Business Intelligence and Standard: Database Mirroring (Safety Full Only)

  17. SQL Server High Availability (By Edition)

    SQL Server Business Intelligence and Standard: Database Mirroring (Safety Full Only) DEPRECATED in 2012, possibly unavailable thereafter

  18. 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)

  19. SQL Server High Availability (By Edition)

    SQL Server Enterprise (and Developer):

  20. SQL Server High Availability (By Edition)

    SQL Server Enterprise (and Developer): Database Mirroring

  21. SQL Server High Availability (By Edition)

    SQL Server Enterprise (and Developer): Database Mirroring Still DEPRECATED

  22. SQL Server High Availability (By Edition)

    SQL Server Enterprise (and Developer): Database Mirroring Still DEPRECATED Failover Clustering (OS Maximum)

  23. SQL Server High Availability (By Edition)

    SQL Server Enterprise (and Developer): Database Mirroring Still DEPRECATED Failover Clustering (OS Maximum) AlwaysOn Availability Groups
  24. The Setup

  25. The Setup

    Quorum Drive pre-built (5GB) on MARS (DC)

  26. The Setup

    Quorum Drive pre-built (5GB) on MARS (DC) Networking pre-built:

  27. The Setup

    Quorum Drive pre-built (5GB) on MARS (DC) Networking pre-built: Heartbeat NIC – Non-routed Storage – iSCSI NIC Intrafarm – All Farm Communications

  28. 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
  29. Step 1 Setting Up iSCSI Storage

  30. Setting Up iSCSI Storage

    Ensure that Windows Firewall is Off, or configure TCP Ports

  31. Setting Up iSCSI Storage

    Ensure that Windows Firewall is Off, or configure TCP Ports Setup iSCSI Initiator on SQL Servers

  32. 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

  33. 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
  34. Step 2 Configure DNS and Install Failover Clustering

  35. Configure DNS and Failover Clustering

    Initial DNS Entries

  36. Configure DNS and Failover Clustering

    Initial DNS Entries Cluster Installation

  37. Configure DNS and Failover Clustering

    Initial DNS Entries Cluster Installation Assign Permissions in DNS to the A Record

  38. Configure DNS and Failover Clustering

    Initial DNS Entries Cluster Installation Assign Permissions in DNS to the A Record Quorum Drive Addition
  39. Step 3 Configure Availability Groups

  40. Configure Availability Groups

    Enable AlwaysOn Availability Groups

  41. Configure Availability Groups

    Enable AlwaysOn Availability Groups SQL Configuration

  42. Configure Availability Groups

    Enable AlwaysOn Availability Groups SQL Configuration Create Seed Database and Backup

  43. Configure Availability Groups

    Enable AlwaysOn Availability Groups SQL Configuration Create Seed Database and Backup Create Availability Group Create Availability Listener

  44. Configure Availability Groups

    Enable AlwaysOn Availability Groups SQL Configurations Create Seed Database and Backup Create Availability Group Create Availability Listener Build Backup Share
  45. Step 4 Configure SharePoint 2013
  46. Step 5 Adding SharePoint 2013 Content Databases to Availability Groups
  47. References 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

  48. Please fill out session evaluations andthank you for attending!

  49. Thanks to our Sponsors!

  50. Contact information:Troy LanphierEmail: t.lanphier@guio.comBlog: http://www.guio.com/troyTwitter: @troylanphier

More Related