We had an outage this morning at our main site that holds the Orion NPM and SQL server and realsed that because the SQL box was down that it showed all devices at our remote sites as being down even thought they weren't.
So my question is how do you have SQL configured ie resilience etc?
The big problem is being an NHS Trust we don't have a big budget so if anyone could recommend a way of making SQL more resilient without costing the earth it would be much appreciated.
Thanks
Jon