One of my customers has more than 200 active and connected users using the same data (around 50Gb). During the night, the data is copied to another server (the report server). So far so good. But users do not want yesterday data, they want on-line data.
I am searching in the internet for a solution that handles this situation easily like server disk mirror technique (I do not know nothing about) or replication. I know it exists in ElevateDB but I do not know how robust it is and how the performance will be impacted when it is turned on (I imagine something around 5 minutes for each replication process).