I have 2 MSSQL databases a Production db(A) and a Backup db (B). Data from Production DB gets updated in Backup DB with a lag of 15 mins. I am trying to get data from Backup DB but due to this lag I am unable to get proper data. There is always a bit of data loss.
Tried querying with tracking column, sql_last_value but still same results.
Can someone please suggest a way to compensate this lag or a better way to solve this issue.
*cant take data directly from prod db as locking occurs on the table.