I need help with this scenario. We have one SQl server, I need to maintain two databases of this server in another physically remote location. An exact copy is not like switching to another resource. Exactly the same data, so if something happens on one, the other should also be, but not like automatically switching to another resource or something else. To synchronize databases, everything that happened in the primary must be synchronized with another. I am very confused about what I should use, replication, mirroring, log shipping.
Can anyone consult?
Thanks for the help!
source
share