Database Mirroring with Automatic Failover || High Availability mode in SQL server || Ms SQL

Automatic failover is supported only in database mirroring sessions running with a witness in high-safety mode (high-safety mode with automatic failover).
In high-safety mode with automatic failover, once the database is synchronized, if the principal database becomes unavailable, an automatic failover occurs.
An automatic failover causes the mirror server to take over the role of principal server and bring its copy of the database online as the principal database. Requiring that the database be synchronized prevents data loss during failover, because every transaction committed on the principal database is also committed on the mirror database.
For automatic failover to improve reliability, the mirror and principal databases must reside on different computers.
Hardware & Software requirements
docs.microsoft...
Data Mirroring (High safety and High Performance mode) : • Database Mirroring in ...

[@mahendrad7446]

Thank you for giving classes

[@Myyutubee]

Thank you for your efforts and sharing knowledge. It will be very helpful.

[@ShahriarMohammadShoyeb]

Thank you for your effort. I really appreciate your sharing knowledge and helped me a lot.

[@edendavodbetossib8818]

thank you for everything . It was really helpful

[@ravindrabathoji941]

Super explanation

[@prakashpathakala8517]

Good video

[@HARISHREDDY-kn5qe]

If we are upgrading sql server from 2012 version to 2014 version which is already mirroring is configuring in 2012,what are the necessary steps in Upgradation process regarding mirroring?

[@devolosfombat7294]

great job

[@sqltechzpestechz7053]

Thank u sir

[@jitendrasharma2301]

Thanks

[@navyasree6152]

thankyou so much ,very helpful.can you please upload interview questions

[@righttolearnbk]

Noted.

[@painkillerO8]

Great Video! How is the application knows which available DB to connect to?

[@righttolearnbk]

Connection string is mentioned at the application side in case of automatic failover . If no automatic failover the Connection string has to be changed manually..

[@painkillerO8]

@@righttolearnbk thank you for the quick response. Where do I get the connection string so I can provide to application team to configure their application server?

[@righttolearnbk]

@@painkillerO8 Connection string is the server name itself or you can also use server ip (In case of named instance port number should also be included)