This appears to be an issue with IO not being able to be frozen: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql

Did previous log restores complete? Are you restoring in standby or norecovery?

My suspicion is that there is one of two things happening.

1. The powershell exe isn't firing for the account in services (not in path, or something else)
2....

That looks like an incomplete command. Do you have Powershell as the program being run? Are you use this is in the path for the system?

I'd do something...

I tend to trust Microsoft as a company. They have made missteps, but none that I consider egregious. I think far, far too many people seem to distrust them for...

It's less a trust issue, and more sometimes a poor wording issue that is ambiguous. I'm sure some people take the docs and it makes perfect sense, but at other...

Thanks, Brandie. Forgot to close this thread. Doing so now.

BOL is probably shite. Test1, Test2 show different maxes, based on ordering.

CREATE TABLE counters
( countid INT IDENTITY(1,1)
, countername VARCHAR(20)
, counteryear INT
,...

I'm not sure we're looking to make vendors liable for users' mistakes. It's more that vendors need to be liable for vendor mistakes, which isn't always the case now.

This is one reason why I like DevOps philosophies. We need to be able to change things. We need a build system that lets us determine before production exactly what...