Getting data from lagging database

Hi Guys,
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.


This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.