Stargate Universe S02 E06 Trial and Error

"The Only Mission Is Survival"

Young is plagued by mysterious dreams where Destiny is destroyed by alien attackers no matter what he does.