Good morning,
I am having a recurrent issue with Ignition & Microsoft SQL Database. The database connection will fault (Set up a connection alarm) and the historian will stop collecting data which results in flat line trends for operators and loss of data for reporting. The only issues I see are included in the photos below.
I have enabled data pruning; assuming that it was a full database causing the issue; but that does not seem to be the case.
Can anyone with more experience point me in the right direction? Thanks!
EDIT: I forgot to mention a PC restart usually solves the issue for the interim
