Plant SCADA Trend Data Logging in SQL

Hello Experts, We are looking solution of Plant SCADA Trend & alarm data logging to SQL Database located at different PC in same network without using Historian server.
How can we Log Trend data to SQL Database without interruption, If communication fails for some time between Plant SCADA & SQL Database after comm restore, automatically Trend data should backfill in SQL.
If we use ODBC connection then it only stores real time Data. We required continuous data logging even if communication fails & restore. Thanks in advance