locked
Off Topic - MS SQL Mirroring RRS feed

  • Question

  • User475570419 posted

    Hello,

    I know this is off topic here, but can anyone point to any good documentation on Mirroring.  I have it set up and running.  I am looking on more information that tells me how to set up an application to use either db.

    Any help is always appreciated.  Sorry if this should not be discussed here.

    Bob

    Thursday, October 5, 2017 12:28 PM

Answers

All replies

  • User269602965 posted

    You have to designate one server as the receiver of data changes, and the other is just a background standby copy of all changes in case of failure of the primary server.

    Now you can switch (role witching) the designation of which server is the master and which one gets the mirror copy, but it is not something where you can write to both at the same time and expect synchronized copies on both.

    Thursday, October 5, 2017 1:13 PM
  • User475570419 posted

    Thank you for the reply.  Is there any good documentation out there that you can recommend?

    Thursday, October 5, 2017 2:47 PM
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, October 5, 2017 7:30 PM
  • User475570419 posted

    Thank you for the link.  It was very helpful.

    Wednesday, October 11, 2017 7:20 PM