I have a guest table on two servers. Call them prod1 and prod2. The Prod1 database is backed up and restored to the prod2 server everyday. The backup starts around 11 pm and the restore the prod2 finishes around 10:30 am
--this is to check what records exist on prod1 that dont exist on prod2
left join [prod2].[xxx].[dbo].guest n --new...this is using a linked server connection
on n.Id = o.Id
where n.Id is null
This returns records with a create data of several days ago. The data on prod1 is refreshed using dbamp from salesforce cloud every 10 mins. It pulls the records changed in the last 30 mins then does a delete and insert not wrapped in a transaction. When I check to see if the records returned exist on prod2, they do. The amount of records changes every time I run it as well. I should only see records being returned that were created when the backup started. Long and short, it is saying the records dont exist on prod2 then when i check prod2 they do indeed exists. Am i going crazy?
- This topic was modified 1 year, 2 months ago by Snargables.