differential backup missing last updated data
I hope if you can help me to figure solution for this issue. I have 40 GB Once a week we run FULL backup but during the week we run a differential backup every hour then we restore the differential backup on ReadOnly DB.
The process is working fine for the past year, lately we notice the differential backup will miss some records that should be included in the bk.
Here is Example to make it easy.
if user changes some records @ 12:40 PM, we will expect the differential backup process when it runs @ 1 PM it will include the changes done @ 12:40 PM.
What we found the differential backup @ 1 PM does not include those changes but later at 2 PM or 3 PM, the differential backup will include the changes done @ 12:40 PM.
As if differential backup include the db changes done 2 or 3 hours ago.
I checked the SQL events, error log, red-gate logs and I could not find any errors.
Is there anyway to make sure the differential backup include last hour changes.
Thank you very much.