What are the advantages of the Mirroring?

Category: SQLWhat are the advantages of the Mirroring?
Editor">Editor Staff asked 2 years ago

What are the advantages of the Mirroring?

1 Answers
Editor">Editor Staff answered 2 years ago

Advantages of Mirroring are:

  • It is more robust and efficient than Log shipping.
  • It has an automatic failover mechanism.
  • The secondary server is synced with the primary in near real-time.