Database Mirroring in SQL

//Database Mirroring

Prerequisite:
---> Primary Server with Database
---> Secondary Mirror server with Database

Operational Mode:
-->Synchronous (With or Without Automatic Fail over)
--->Asynchronous

Note: Automatic Fail over - > When primary server Database becomes unavailable or disconnect, Mirror server Database will Take copy to Database online as Primary Server DB

Steps to Configure:
1) Connect Primary Server DB with SQL admin rights credentials
2)  Primary Server Database should in Full Recovery Model
3) Right click (Primary Server Database) ->Tasks-> mirror
4) Select option Configure Security Database mirror wizard to configure DB mirroring
5) Select with or with out Fail over option by Yes/No
6) Enter Primary Server Instance name and Port number(5022)
7) Mirror server instance name and Check/Verify connection setting
8) Once connection setting verified without any Failure, proceed to next step
9) Enter Service Account for Primary and Mirror server instance Database
10) Click Finish and Start Mirroring

Verify Database Mirror Option:
1) Right Click on Primary server instance Database and select Properties
2) In Database Mirror Tab, Now you can find out Principal(Primary) and Mirror server DB details

Verify Operation Mode:
Selected

High Performance (Asynchronous) - Commit changes at primary server DB and then transfer them to Mirror server DB
or
High security without automatic fail over (Synchronous) - Always Commit changes at both primary and mirror server DB