You'll need to play Motorhead's "Killed By Death '08" in a Band context for this achievement to work, with a minimum of two active instruments. Playing by yourself on Expert in a solo career and not failing will not suffice. Outside of that, the instruments selected (and whether you use Quickplay or a Band Career) appears not to matter, just so long as no member fails out in mid-song. (We did this with me on vocals and my wife on drums with zero difficulties encountered.)
If you're having a tough go of things: it's probably best to not activate overdrive unless one member of the team has their rock meter dipping into the red, keeping it in reserve until then. If anyone has overdrive activated, it'll help the rock meter of all members of the band, so only have one person maximum with overdrive running at a time. Additionally, if you're only using two people, it could be beneficial to have them on two non-microphone instruments; that would make the instruments offer unison bonuses throughout the song, awarding the band more potential overdrive to work with.