403 is an HTTP error. Perhaps HTTPS is now being enforced?

Your solution sounds more complicated than it needs to be, but well done on working out something usable.

May I suggest that in future you do as I suggested and provide...

It helps people if you format your code as a code sample. Here is your code again:

--V1:
WITH cte_filterdates
AS
 (SELECT TOP 1
      ...

1. You have stated your requirements, but not asked any questions. What do you want assistance with?

2. If you are hoping for coding assistance, please provide sample DDL, along with...

This syntax works ... not sure whether it gets you where you want to be.

DECLARE @TheDetails VARCHAR(MAX);

SET @TheDetails = 'The Following Items Have Changed: ';

IF 1 <>...

I don't know the answer, but if I were you, I would focus my initial attention on understanding this particular part of the error message:

The remote server returned an error: (412)...

• This reply was modified 4 years, 10 months ago by Phil Parkin. Reason: Fix typo

One thing I can think of is to set up an alert which detects 'long running jobs'. There are many ways of doing this, but one is to have another...

One additional thought.

You can future-proof the separate database idea to a large extent by using database schemas which are different from those in your existing database.

If you do this and...

OK, that's a good reason, thank you.

To be honest, I can see only a few pros of putting the new tables and structures into the same database as your current...

... creating new database and porting it's table structures ...

Why would you even consider this, when you have BACKUP/RESTORE as the obvious alternative?

Does this 'system' already have its own database? What is the reason for this migration and why are you considering throwing away the existing database?

As the data in the 'system'...

OK, no idea what's going on here. Stored procedures get executed, not pulled.

If your application worked fine on one server but not the second, I'd suspect either a configuration error...

Please explain what you mean by "... unable to pull into application ...".

Which application? What do you mean by "pull"?

• This reply was modified 4 years, 10 months ago by Phil Parkin.

What is the purpose of this CLR and how does it relate to SQL Server?

If you know the folder path in advance, you can simply remove it to get the file name:

DECLARE @BackupFilePath VARCHAR(300) = 'E:\Backup\Server1\Database1\Database1_131983519013.bak';

SELECT
    @BackupFilePath
, ...