Two SQL servers for one website I have a website that is deployed on an environment as follows:


a load balance.
two web server.
two database servers.


both of the two database server have the same structure and queries.
I found out that each one of them is storing different data than the other one and not connected.

i do not know much about this. i just need that any update that occurs on any servers be reflected in the other server.

EDIT:
I stopped one of the servers and work on only one of them until we try the replication as it seems to be a wrong configuration.
Load balancing writes in SQL Server is hard. Are you sure this is actually a requirement? If not, and the servers just ended up this way because the implementers didn't understand the requirement, I would start with a single copy of the database that both web applications use, instead of trying to give each database an independent copy.

If it really is the requirement, then you could look into Distributed Partitioned Views, Peer-to-Peer Replication, Bidirectional Replication, or Merge Replication, all of which allow you to combine writes or otherwise share data from multiple instances. My guess, though, is that these solutions are overkill for your actual business requirements.