High Availability Solution Database Mirroring in SQL Server 2008 R2


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 

Advertisements

About Mustafa EL-Masry

I love fixing problems and learning new technologies that can help me fix those problems faster and better than I did the time before. In my spare time I like to read, speak, write blogs and learn new things. I currently work as a Principal Database Administrator where I solve fairly interesting problems on fairly large databases. And troubleshooting High sensitive Performance Cases ► I am Microsoft Certified in SQL Server Administration and Development 2008 , 2012 MCTS, MCTIP , MCSA , MCSE ► I have deep practical knowledge about T-SQL performance , HW Performance issues, Data Warehousing and data mart solutions , SQL Server Replication, Clustering solutions (Active Active and active passive)and Database Designs for different kinds of systems , HAG, I worked on All SQL Server Versions (2005,2008,2008R2,2012,2014) diving deeply more check the below information about me : ► Founder of Community :SQL Server Consultation :http://MostafaElmasry.com/ ► Co-Founder : http://www.SQLGULF.net ► Audience Marketing Manager and Executive Board member: SQLSERVER PERFORMANCE TUNING http://sqlserver-performance-tuning.net/ ► LinkedIn: https://www.linkedin.com/in/mostafaelmasry ► My Community Annual report : http://mostafaelmasry.com/2014/annual-report/ ► I am Technical Writer and Reviewer : http://www.slideshare.net/MostafaElmasry3/ ► Fluent Participator at Microsoft Forums of SQL Server at http://Social.technet.microsoft.com ► +200 blogs in SQL Server technology English and Arabic: http://mostafaelmasry.com/community-founder/all-tips/ ► Microsoft Profile: https://www.mcpvirtualbusinesscard.com/VBCServer/EngMostafaElamsry/profile For any inquiries you can contact me on my phone or by mail: Mobile: +966 543990968, +2 01114668821 Mail: dbconsultant@mostafaelmasry.com & SQLGULF@mostafaelmasry.com
Gallery | This entry was posted in Home. Bookmark the permalink.

Leave a Reply

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

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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s