Which link?

I should share. I've been lucky to usually not be on call except for something unusual, but I've had a few good ones.

Working at the nuclear power plant,...

Can you go back and verify the names on source databases? The logical name wouldn't change unless you changed it in a source. At least AFAIK.

The permissions thing...

Nope, logical names in the backup are what's in the db. Perhaps you have the wrong file?

The main problem I see is that you different numbers of columns in each query. You need the same number of items in the select list

select ...

RIP, Tom Roush : https://twitter.com/GEEQL/status/958432639286784000

You're not really explaining the issue you are having. I get that you want a sort order among the queries, but what don't you understand or what doesn't work?

This requires data movement. No way to restore and make smaller files. You could combine disks into a volume, essentially a RAID 0 approach, which is fine if this is...

Diffs more often mean less logs to restore. However, the diff does grow, as Grant mentioned, and it's rare you'll restore. I would tend to say that you're trading off...

That is a security error. My guess is something had issues when you restored.

That script doesn't restore, so I'm not sure what you did there. That gets...

Not that I think this is a good idea, but once you have the db, or db files, you would use a PoSh command to execute dbcc shrinkdatabase or dbccshrinkfile.

As Jeff noted, it could be because of hardware or poor code. If you benchmark the disk, is it slower than others?

Are there certain days/times/functions that cause...