Hi guys today i will share not explain the most important point in SQL Server  Mirroring Solution i will not explain because i already explained it before in 8 posts to download the Technical Document

High Availability Solution Database mirroring or you can Check it onlinehttp://www.slideshare.net/MostafaElmasry3/high-availability-solution-database-mirroring

Agenda and overview :

  1. Introduction about Database Mirroring Concept
  2. Note
  3. Database mirroring operation mode
  4. Database Mirroring Requirement
  5. Advantage of Database Mirroring
  6. Disadvantage of Database Mirroring
  7. Database Mirroring Enhancement in SQL Server 2008
  8. Database Mirroring Installation Step by Step
  9. High Availability Mode [Automatic Failover]
  10. High Availability Mode [Manual Failover]
  11. High Safety Mode Without witness server [Manual Failover]
  12. Stander listener port in database mirroring
  13. Check SQL server mirroring availability
  14. Add or replace witness server to an existing mirroring database
  15. How to monitor Database Mirroring
  16. Mirroring in workshop not in DC (Domain Controller)

Reference : 

Mirroring in SQL Server (8/8)
Mirroring in SQL Server (7/8)
Mirroring in SQL Server (6/8)
Mirroring in SQL Server (5/8)
Mirroring in SQL Server (4/8)
Mirroring in SQL Server (3/8)
Mirroring in SQL Server (2/8)
Mirroring in SQL Server (1/8)

Follow the author:

View all my tips , LinkedIn , Website , Slideshare 

Published by Mustafa EL-Masry

I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page https://mostafaelmasry.com/about-me/

2 thoughts on “High Availability Solution Database Mirroring in SQL Server 2008 R2”

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.