Sunday, November 20, 2011

Database Mirroring Components In SQL Server

Here is the Database Mirroring components in details. 

1. Principal:  The Principal is the source server which contains the database which is configured for mirroring. There can be only one principal database. 

2. Mirror:  The Mirror is the destination server which contains the mirrored database. There can be only one mirror for each principal database. 

3. Witness A Witness is optional and it monitors the Mirrored Pair. It ensures that both principal and mirror are functioning properly. One Witness server can monitor multiple Mirrored Pairs. 

4. Mirrored PairA Principal and Mirror operating together are called a Mirrored Pair. The changes on the principal are reflected in the mirrored database. 

5. Quorum:  A Quorum is the relationship between the Witness, Principal and the Mirror. 

6. Endpoint:  Endpoint is the method by which SQL Server Database engine communicates with applications. In the context of Database mirroring endpoint is the method by which the Principal communicates with the Mirror. The mirror listens on a port defined in the endpoint. The default is 5022. Each database mirror pair listens on its own unique port.

If you want to list all the database mirror endpoints run below script.


Select * from sys.database_mirroring_endpoints

Prerequisites. Restrictions. and Recommendations for Database Mirroring. Prerequisites and Recommendations for Database Mirroring. SQL Server Database Mirroring Pre-requisites and guidelines. Prerequisites for Database Mirroring. Database Mirroring in SQL Server 2008. Prerequisites: Configuring database mirroring or database. Introduction to Database Mirroring. Setting Up Database Mirroring. Database Mirroring Witness. Database Mirroring Sessions. Configure availability by using SQL Server database mirroring. Setting Up Database Mirroring. Database Mirroring Best Practices and Performance Considerations. Things to consider when setting up database mirroring in SQL Server 2012. Database Mirroring and Other Features and Components, Database Mirroring Components In SQL Server 2012, Database Mirroring Components In SQL Server 2008 R2,

0 comments:

Post a Comment