My first project setting up a redundant server:
-2 PC’s each with
– Ignition 126.96.36.199 (testing right now) Logging to Historian Spliter (pointed at each SQL express)
– MS SQL Express
Both DB’s get the same data, looks good.
when Backup reboots, Data looks good after recovery.
when Server reboots…
-any data collected in the backup SQL instance stays on the backup and is not available to charts after the master is back on-line.
Question: is there a way to make those rows show up in the SQL instance on the master?