Answers

Question and Answer:

  Home  SQL Administrator

⟩ Tell us what is the difference between the 2 operating modes of Database Mirroring?

☛ High-Safety Mode is to ensure that the Principal and Mirrored database are synchronized state, that is the transactions are committed at the same time on both servers to ensure consistency, but there is/might be a time lag.

☛ High-Performance Mode is to ensure that the Principal database run faster, by not waiting for the Mirrored database to commit the transactions. There is a slight chance of data loss and also the Mirrored database can be lagging behind (in terms being up to date with the Principal database) if there is a heavy load on the Mirrored Server.

 164 views

More Questions for you: