Steps for Configuration of Mirroring setup

➤ Prerequisites for Mirroring:

Steps to configure mirroring.

Step 1 : Connect to DB.

Step 2: Right click on DB --- > go to properties

Step 3: Click on Mirroring (In select a Page)

Step 4:- Click on Configure Securities:

 Step 5: Configuration DB mirroring security wizard will open & Click on NEXT

Step 6: Select yes if witness server is there

Step 7: 

• Connect to Principle server
• Add Port number , if do not want to use default
• Provide Endpoint name

Step 8 :

• Connect to Mirror server
• Add Port number , if do not want to use default
• Provide Endpoint name

Step 9 : 

• Connect to Witness server , if any
• Add Port number , if do not want to use default
• Provide Endpoint name

Step 10 : Provide service account name who has read write access on other servers (Principle , mirror , witness if any)

Step 11: Summary of configuration settings and click on finish

 Step 12 : All three action executed successfully.

Step 13 :- This window will ask you to start mirroring. Before click on start mirroring cross verify that you have restore database in NORECOVERY MODE on mirror server. 

Many times you may face issue in this step. Check the errors & resolve it

Step 14 :- Final output of Mirroring setup 

This Window allows you to perform manual failover of DB, pause mirroring & remove mirroring.

  

Thats it :)