prevent second hard-drive from spinning up after standby
Running your script on wake up, with Power Manager, or using SleepWatcher, for instance, should do the trick.

There are, actually, different sleep modes, and knowing exactly which one you are using may help too, as Sleeping your Mac should not use the Hard Drive, the second disk should stay idle. Here is a brief explanation of what happens with each sleeping mode.