Yes, the login isn't correct. That's what the error is.

The best way to speed up backups is to stripe them. The SQL engine can then spew out pages to multiple locations. If you have good hardware, I'd look at...

Does it pause at the same point each time?

I'd start to break apart the package and test things separately. Pick a certain item, then make a new package to do...

I like the idea of altering the temp file to include missing columns. It's a  simple solution that means the important part, the reads, don't change and you don't get...

Consummable data means posting the CREATE TABLE statements, with some INSERTs for sample data. Not just describing the columns.

+1 for Brian's thoughts. The indexing is driven by the query patterns.

This isn't out of the box. SQL Prompt does this, as does SSMS Tools Pack, but you pay for both.

Disclosure: I work for Redgate, developer of SQL Prompt.

I'd agree with you, but how do you prevent someone that admins a database from making a change? Our platforms don't do a great job of preventing this. Something like...

That's a good system, Chris Wooding. Not perfect, but likely it works well unless you have a rogue admin. I still like the idea of using a pipeline of sorts...

I'll post a note to Microsoft and see if I can get a response.

I didn't 😉

Nope, that was all I wanted to say. I'll add in the a few more words.

To add to what Grant said, create the role in your database and then add the group (I assume this is an AD group) to the role with ALTER ROLE...

Is that the only output? Isn't there something from DBCC besides what you are returning?

You are running EE, so no memory limits. 64GB might be small these days. I think I'd go to 128GB at a minimum or 256 if I think this workload...