Loading

Data storing redundancy

Aruljothy Sundaramoorthy

7y854

*Please refer the diagram from attached .zip

Need a proper clarification

the data was logging at the main server though server 1 and 2. I Need the data even any of the server (ie server1 or 2 )gets fails (ex: power failure). there should not any duplicates during both server performs at the same time. in the main server

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gajendra Jangid7y ago
hello dear,

please have a look at below links:

https://stonefly.com/blog/implementation-of-data-redundancy-in-data-storage
Nirav Gandhi7y ago
HI,

You have to go with HA and DR database technology in Server.

Before give solution.Please provide following details.
What version of SQL Server/Edition are you using?
No of Tables
HA (High Availability)
Always on
Database mirroring

DR:
Log Shipping
Replication ( Table Level)