Data storing redundancy

Jun 4 2019 2:14 AM

*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

Attachment: Capture.zip

Answers (2)

I need to excute a .SQL file from CMD line but i got this:

Is sql server 2008 database compatible to run on sql 2016