When you execute the program, I assume you're executing the console program. That means your security context. Are you running this from your machine or the server?

Agent can...

You haven't really explained what is happening. Moving data from other servers to Server B, what does that mean? What do linked servers have to do with this?

The...

Are you asking about setting up replication across the Internet? I assume you want transactional from your hosting provider to a VM in EC2. This is all about authentication and...

No one deletes rows from this DMV. The system manages this. This is a view, not a table of data. The data you want won't be in a backup.

If anyone wanted to tackle another side of this, that would be great.

I think your tone, Patrick, was fine. I didn't like it, it didn't relate to me, would have preferred x or y. That's great.

Leaving a comment like "So...

Interesting, please let us know if this seems to fix things.

Your results are incomplete. You have more than 2 dates in the source you've listed. That's what I mean by calculating all results. Don't pick a few and think you've...

First, you need to set up test instances and test. DO NOT JUST TAKE ADVICE. You have to test things. You don't need a copy of production, but you need...

It's just good coding. Checking for potential and common problems is what we should all do and rarely do. If there's one good thing about the cloud, it's that these...

What data is in the empty spaces? This isn't Excel. Either a null, blank space, something is there.

Look at dbatools.io as well. You could use a scheduled task that would be easy and trivial to write with their cmdlets.

I'd send an email with the observation and recommendation to my manager and keep a copy. Then let them decide what to do.

Ensure you've  met your obligations, but...

Hmmm, I hadn't noticed. I'll check.