Indeed, Jeff, that operational metadata should be...

another reason to keep up your software level 🙂

If you want to do that using Powershell, I suggest you use SQLSMO or DBATools.

that is a (local) windows managed account, not a group!

double check the path to the sqlagent step log file. Something must be off

Did someone modify the SQLAgent service account after the installation of this sqlserver instance ?

Here is the problem !

Your final query is

INSERT INTO dbo.TAllData(PartID
                 ...

did you specify the "ApplicationIntent=ReadOnly" parameter with your connection and is you secondary readable?

I put dev in read-only restricte mode ( with rollback immediate ) to force everybody out, before attempting to restore.

is SQLServer Configuration Manager working OK ?

ref: configuration-manager-is-corrupt

Add RAM & SSD ( especially for tempdb )

FYI Many of the production restores I've had to perform was due to devs learning the delete statement.

BTW I messed up a couple of client machines myself tampering with powershell...

• This reply was modified 3 years, 9 months ago by Johan Bijnens.

Indeed, Jeff

create clustered index ci1 on z1(id) --> creates a non-unique clustered index ( that holds the data at leaf level ! )

alter table Z1 Add constraint PK_Z1 primary key (id)...

• This reply was modified 3 years, 10 months ago by Johan Bijnens.

Check out dbatools.io Export-DbaDbTableData