That was where my problem started, dynamic SQL will do the job but isn't elegant or efficient and won't work in a view hence why I asked the question in...

I've previously found this forum to be a community and so it's a shame if some people feel the need to be unpleasant.

I hold my hands up, I did indeed...

Turns out that SSISScaleOutMaster is the problem - I hadn't gotten around to creating the SSIS catalog, all sorted now!

Just in case it is of interest to anyone else, I did finally solve this problem and have had a repeat and resolved again.

The fix at the time...

Thanks - that's my suspicion too, it's not the hassle of getting log shipping running, it's the transfer of data that was truly painful & the head stomping that comes...

The log recovery completes a "writing checkpoint" entry and then I get a memory dump and a severity 16 assertion alert (which when I try to paste this reply closes...

No I didn't mean to post this twice, after the "loading" message it looked like nothing had happened so I pressed the button again and now there are 2!