I am new to DB mirroring, need experts help on this technology.
We have to implement DB Mirroring in one of our PROD server with automatic fail-over
(If primary Node has any issues then automatically
switchover happens and secondary node becomes primary Node and there will not be any impact on application services
I have created document to configure DB mirroring using TSQL commands. Please review the attached document and provide below clarification on this technology.
1. For automatic fail-over, what SQL commands we need to execute on Witness server (I have not added witness server SQL commands in the attached document because I am not clear on witness server).
2. Please share SQL commands for automatic fail-over configuration with detail.
NOTE: We have chosen automatic fail-over because the customer is expecting 99.9% application uptime.