How to Set up Database Mirroring in SQL Server 2008 (Video)

Leave a comment (5) Go to comments

Database mirroring is an alternative high-availability solution to failover clustering in SQL Server Enterprise. Database mirroring supports automatic failover, but does not require cluster-capable hardware, and can therefore provide a cost-effective alternative to failover clustering.

This article is not focused on to make you understand Database Mirroring Concept, rather this focuses on How to implement “Database Mirroring in SQL Server 2008

To Watch this video, you must have silver light installed in your system.


In case you are not able to watch this video, check out my another post “How to Setup Mirroring in SQL Server ?(Screen Shots)

Here are the definition of some terms, which are being used in this video which is directly related to Concept building.

What Is Database Mirroring?

To have the Database Mirroring Overview, click here.

Database mirroring is a simple strategy that offers the following benefits:

  • Increases data protection.
  • Increases availability of a database.
  • Improves the availability of the production database during upgrades.
Operating Modes

How to Set up Database Mirroring in SQL Server 2008 (Video) sql server Witness server sql server Principal server sql server Mirror server sql server How to Set up Database Mirroring SQL Server Database Mirroring Set up Database Mirroring video How to Set up Database Mirroring in SQL Server 2008 how to configure Witness server how to configure Principal server how to configure Mirror server how mirroring is configured to provide availability of high availability Database Mirroring step by step guide video Database Mirroring step by step guide Database Mirroring sql server Database Mirroring in SQL Server 2008

Key Points

  • Database mirroring provides an alternative-high availability solution to failover clustering. Database mirroring can be implemented with standard hardware, and all administration takes place entirely within SQL Server.
  • In a database mirroring solution, a database is stored on one server and copied to another, providing a standby copy of the database that can service clients in the event of a server failure.
  • Database mirroring cannot be used on system databases.


Server roles in a database mirroring solution are:

  • Principal server. The principal server hosts the active copy of the database (referred to as the principal database) and services client requests. The principal server forwards all transactions to the mirror server before it applies them in the principal database.
  • Mirror server. The mirror server hosts a copy of the principal database (referred to as the mirror database) and applies the transactions forwarded by the principal database to keep the mirror database synchronized with the principal database. \
  • Witness server. The witness server is an optional component of a database mirroring solution. When present, a witness server monitors the principal and mirror servers to ensure continued connectivity and participation in the mirror session (referred to as quorum). If either server loses quorum, the witness server assigns the principal server role, causing automatic failover from the principal server to the mirror server if necessary. A witness server is required for automatic failover; however, one witness server can support several mirror sessions because it is not an intensive job.

The following figure shows how mirroring is configured to provide availability of high availability

How to Set up Database Mirroring in SQL Server 2008 (Video) sql server Witness server sql server Principal server sql server Mirror server sql server How to Set up Database Mirroring SQL Server Database Mirroring Set up Database Mirroring video How to Set up Database Mirroring in SQL Server 2008 how to configure Witness server how to configure Principal server how to configure Mirror server how mirroring is configured to provide availability of high availability Database Mirroring step by step guide video Database Mirroring step by step guide Database Mirroring sql server Database Mirroring in SQL Server 2008

Please check my another post How to Setup Mirroring in SQL Server ?(with Screen Shots), which describes:

  • What is the Hardware and software requirement for implementing Mirroring in SQL Server ?
  • How to implement Database Mirroring in SQL Server 2008 R2 with Step by Step Guide with Screen shots.
  • Testing of Manual  mirroring fail over
  • Testing of Automatic  mirroring fail over using WITNESS Server
  • Please check my other post to know

    Feel free to contact us, in case you have any issues in implementing “Database Mirroring in SQL Server 2008” or any consultancy project.

    EOF - How to Set up Database Mirroring in SQL Server 2008 (Video), SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
    Leave a comment

    5 Comments.

    1. This video isn’t showing up for me. Silverlight is installed. Anyone else having this issue?

    2. Ted;

      Any luck? Can you post your environment?
      Principle:
      OS:
      OS service pack:
      Database edition:
      Database version:
      Database service pack:
      Database architecture (x32/x64):

      Partner
      OS:
      OS service pack:
      Database edition:
      Database version:
      Database service pack:
      Database architecture (x32/x64):

      Network:

      LAN/WAN:
      Subnet: same or different
      javascript:grin(‘:roll:’)

    3. I cannot get the witness to be added to the Mirrored session of SQL 2008 R2 CU4. I have done everything by the book but no cigar…

      HELP! :!:

    Leave a Reply

    Your email address will not be published. Required fields are marked *


    *


    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    Notify me of followup comments via e-mail. You can also subscribe without commenting.

    Trackbacks and Pingbacks: