Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Multi-Cloud Service Orchestration & Delivery Platform

SharePoint 2010 – Ensure High Availability with SQL Mirroring

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:

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