Is it possible to specify a standby server in the MS SQL database connection string?

Question

SQL

Actually the essence is in the title, I know that Oracle can have a spare server in TNS, but is there something similar in the case of MS SQL? Googling didn't turn up anything meaningful

Answer 1

In the case of MSSQL, there is mirroring, while a backup server is registered, completely duplicating the main one, and when the first is turned off, the second seamlessly picks up all the work, when the first is turned on, synchronization occurs, and the request goes back to the first.
Proof msdn