Multi-Cloud Service Orchestration & Delivery Platform

SharePoint 2010 – Ensure High Availability with SQL Mirroring

In Microsoft SharePoint
March 19, 2012
1 Min Read
S

High Availability – Data Tier

SharePoint 2010 provides rich integration with SQL Server enabling SharePoint administrators to leverage the high availability solutions provided by Microsoft SQL Server. Changes include support for the Fail-over_Partner keyword, which enables SharePoint 2010 to natively interpret/translate and respond to state changes in a database mirroring topology. Following is brief of how to accomplish SQL Mirroring.

SQL Mirroring – The Native Way

Since SharePoint 2010 has built-in support for SQL mirroring so farm administrator can configure the SQL environment to mirror a SharePoint content database. When a new database is created, the SharePoint administrator will be prompted to enter the fail-over server. SharePoint then communicates with the witness server, and if issues are discovered, SharePoint will fail-over to the hot backup of the environment. Following image shows the configuration:

Related posts:

  1. SharePoint 2016 New Features and Improvements
  2. Gateway to Cloud Automation: A Unified Approach
  3. Complete Support for Exchange 2013 – SharePoint 2013 – Lync 2013
  4. SharePoint 2010 – Host-Named Site Collections Using Powershell
  5. SharePoint 2010 Redundant & Virtualized Farm
FacebookXReddit

Read more

September 21, 2020

Tips to use Excel Web Access Web Part effectively

In Microsoft 365, Microsoft SharePoint
September 21, 2020
3 Min Read
21September

This post is about using the Excel Web Access Web Part to dynamically show a workbook. The Problem Many times, customers reach out to know more about Excel workbooks. Presently, SharePoint online offers a script editor or content editor to make users display Excel workbooks in an iframe. It is quite possible to write a jquery code within the script web part and dynamically set the excel workbook...

Read on
July 21, 2020

5 Exciting SharePoint Online Benefits for Business

In Microsoft SharePoint
July 21, 2020
3 Min Read
21July

Modern SharePoint Online benefits are many, but the most important benefit is: SharePoint lets you do adopt a faster, simpler, and more sophisticated approach towards doing cloud-based business in modern times. In the past couple of years, having a centralized server and managing documents and collaboration was considered a more tech-savvy approach. However, with the rapid adoption of the cloud...

Read on
April 2, 2020

3 ways MachPanel can boost your business profits

In Cloud, CSP, Dynamics 365, Hosting & SaaS, Hosting Control Panel Migration, MachPanel Control Server, Microsoft 365, Microsoft Azure, Microsoft Dynamics CRM, Microsoft Exchange, Microsoft Hyper-V, Microsoft Office 365, Microsoft SharePoint, Microsoft Skype for Business, Microsoft Teams, MSPControl, Remote Desktop Service, Work Folders
April 2, 2020
3 Min Read
02April

In the competitive world of cloud computing, the key to cloud business growth is having a higher profit margin. Since independent cloud sellers wish to have a good way to show their offerings, with a little bit of help, they can boost their business profit margins and fly smoothly in the cloud marketplace. MachPanel is a robust platform that favors cloud providers and makes them do more with less...

Read on
Multi-Cloud Service Orchestration & Delivery Platform

Connect with MachSol

MachSol is Microsoft Certified Partner and Microsoft Validated Vendor having years of experience in cloud automation industry.

Categories