Wonderful article. I followed you completely up until almost the last sentence - where you used the ambiguous term 'opposite' in the Q&A section:

'Scripting the database will work wherever restoring a backup will work, but the opposite doesn't always hold.'

Which logical opposite? Are you saying that scripting will not work wherever a backup will not work, or that scripting will not work wherever a backup will work, or that a backup will not work where scripting does (not) work, or ....

And, how would you build a (syntactic) test script for that sentence anyway?

Great job!