It only works for Doubles and Triples
It is a normal stat boost, so it stays until the target switches out or its stat changes are reset by a move such as Haze.
The target's Special Defense will be +2 if used twice.
Source