After doing some digging, it appears to be a TLS issue.

The working server was working on TLS1.2, while one of the non-working servers was on SSL/TLS (not TLS1.2).

I haven't had...

@phil - thanks for that.

Now just got to figure out how to check what each box is using.

I used the database I chose for a couple of reasons:-

1. it's small so doesn't take long to restore
2. There's been a least one server-level backup between the full and...

@jasona.work - Thanks for that, at least it means I'm not going insane.  I'll speak to our infrastructure team to see exactly what the backup application does in...

• This reply was modified 1 month, 3 weeks ago by  richardmgreen1.

In some semblance of order:-

@jasona.work -

• Is it only the one database running into this, or are there others (or all of them?) - all full backups are...

• This reply was modified 1 month, 3 weeks ago by  richardmgreen1.

@jasona.work - no, it uses dynamic SQL to do the backup (full or differential). We do have a server-level backup done by a 3rd-party but that's only the...

@Coffee_&_SQL - I had thought of that but we've got as table that contains the databases that need to be backed up (with dates for the next full backup) and...

Bit late to the party on this one (only just seen the article).

Instead of using FOR XML PATH, there's a new function (I've only just started using it on SSMS...

Cheers @phil.  It's not my SSIS package either but I don't think it would be difficult to swap the FST for a script task of some description.

Hi @phil - yes it is.  It's the only place I can find the error (job history just points me to the execution history).

@phil - I've split it now. Might try dynamic SQL to see if there's a speed gain (unlikely to be anything worth mentioning)

Hi all

Found the answer to my own issue (I hope).

It looks like you can't add and update a column in the same batch.

I've split the script into two stored procedures...

That's it!!!

Thank you.

And I've now got them on a specific toolbar (it's just a bit weird that you still have to refer to them as External Command 1, etc even...

• This reply was modified 5 months, 1 week ago by  richardmgreen1.

Had a bit of a browser hiccup so this is posted twice.

Please delete this duplicate if you can?

Thanks @phil - Looks like I spent time yesterday trying to do the impossible.

Writing to a table it is.